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] <> “”   


More information on using Null and other Conditional Logic can be found on the Help & FAQ page in REDCap


For additional assistance, please contact the REDCap Support Team