Creator Help

isNull

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

Description

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

Syntax

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. 

Example

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

isNull(today);  // returns false


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

Top