How do I use Null in Conditional Logic

How to use proper syntax for using Null or not Null in a logic statement


Single or double quotes must be used to designate the value of a field. The lack of a value in a field response or Null is indicated by the same method, either a set of single or double quotes.

Examples:

[field_1] = ‘’   

[field_1] = “”  


Similarly, you can create logic to express a value which is Not Null, or contains any value other than no value at all. A perfect use case for this would be showing a field only if the previous question contains a value

Examples:

[field_1] <> ‘’   

[field_1] <> “”   



For additional assistance, please contact the cru@ucalgary.ca