1. Automate
2. Documentation
3. coalesce

coalesce

value coalesce(value1, value2, …, valueN)

Returns the leftmost argument value that is not null.

To instead return the leftmost argument that do not evaluate to false use the Logical OR (||)operator.

Parameters

1. value1 — first number or text.
2. value2 — second number or text.
3. valueN — N-th number or text.

Returns

• the first non-null value, or null.