Troubleshooting Conditions for Columns of Type Number

Troubleshooting Conditions for Columns of Type Number

Issue:

You are using the Conditional Branch widget to check if a column called Favorite Number is blank. Favorite Number is a column of type Number.

You add a Conditional Branch widget to your workflow and configure it like this:

CB config.jpg

You find that regardless of whether a number is entered in the column or not, the workflow always travels down the False side of the branch. In other words, the workflow always thinks the column is not empty.

Resolution:

Number columns are actually never empty. A number column that appears to be empty actually has a value of 0 (zero). So instead of checking if that column is empty, check if it is equal to zero.

equal 0.jpg