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


The isNullfunction 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

Share this post : FacebookTwitter

Still can't find what you're looking for?

Write to us: