This topic describes the syntax and usage of the isNull function in Zoho Creator.


The isNull function returns true if the field value /expression of type int, decimal, timestamp, string is null.


isNull(<expression>);   // This format is supported only in free-flow scripting mode of script builder.

The isNull function syntax has the following arguments: 

expression - Required.  A string field or an expression that can be converted to int, decimal, timestamp, string format.

Return Value

Returns true if the vlaue is null. 


Name="Zoho Creator" 
isNull(Name)   //returns false

isNull(today);  // returns false

text=" "
isNull(text);   // returns true