Start a conversation

Validation or dependency on an empty field

See here how you can allow empty fields in a calculation.

If you want to create a validation warning or a dependency when there is no data entered in a field, you can use a calculation field to check if any data is entered. Use the following calculation:

'##allowempty##';
if("{Variable}" == "'NA'"  || "{Variable}" == ""){ 
    "Nothing filled in"; 
} else { 
     "Variable is filled in"; 
} 

You can replace the word Variable with your own variable names. If you want to create a validation message, you can set a validation on this calculation field. If you want to create a dependency you refer to the calculation field in your dependency. 


Please note that it is not possible to calculate with empty cells in a grid field. 

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Tonya

  2. Posted
  3. Updated