ifEmpty

Prev Next

See also: ifEmpty, if (if, then, else), cmp (Compare), trim (Calculation expression – cutting off whitespaces)

The function $ifEmpty follows the same rules as if (if, then, else), except that a fixed value or expression to be checked for empty is passed as a condition.

Tooltip

Syntax: $ifEmpty(expression,thenValue[,elseValue])

Parameter

Description

expression

A fixed value or expression which is checked for empty. If the value is empty, the expression thenValue is evaluated, otherwise the optional expression elseValue.

â–ºIMPORTANTâ—„ The transferred value is cleared of leading or attached whitespaces (e.g. spaces, tab, etc.).

Thus a value, which consists only of spaces, is considered empty.

thenValue

A static value or expression that is evaluated and returned when the value of the expression is empty.

elseValue

An optional value or expression that is evaluated and returned if the value of the expression is not empty.

Returns the evaluated fixed value or the return of the evaluated expression. If the value to be checked (expression) is not empty and no elseValue is specified, the function returns null/empty.

Example: $ifEmpty($el(12),field with id 12 is empty,field with id 12 is not empty)

Syntax

$ifEmpty(expression,thenValue[,elseValue])

Parameter

Name

Description

expression

A fixed value or expression which is checked for empty. If the value is empty, the expression thenValue is evaluated, otherwise the optional expression elseValue.

â–ºIMPORTANTâ—„ The transferred value is cleared of leading or attached whitespaces (e.g. spaces, tab, etc.).

Thus a value, which consists only of spaces, is considered empty.

thenValue

A static value or expression that is evaluated and returned when the value of the expression is empty.

elseValue

An optional value or expression that is evaluated and returned if the value of the expression is not empty.

Return value

Returns the evaluated fixed value or the return of the evaluated expression. If the value to be checked (expression) is not empty and no elseValue is specified, the function returns null/empty.

Example

Syntax

Result

$ifEmpty(Jonas Abend,empty,not empty)

not empty

$ifEmpty(0,empty,not empty)

not empty

$ifEmpty( ,empty,not empty)

empty

$ifEmpty( ,empty,not empty)

empty