User Tools

Site Tools


Coalesce(value, value, ...)

Returns the first value that is not an empty value. The function can have at least 2 and at most 6 arguments.

Example Result Remark
coalesce(empty(),'ABC', '') ABC
coalesce(empty(),'', 'ABC') Empty text value (but not an empty value)
coalesce(empty(),empty()) Empty value


To use the function with more than 6 arguments, nest function calls. Keep in mind that arguments are evaluated before a function is evaluated.

See also

syntax/functions/coalesce.txt · Last modified: 2021/05/14 15:02 by dmitry