Skip to main content

DefaultIfNull

This formula allows you to conditionally return a default value if another one is null.

JSON Format

{
"type": "defaultIfNull",
"components": ...,
"default_components": ...
}

Fields

FieldTypeRequiredDescription
componentsStatFormulaComponentThe formula for the main value. If this formula returns a non-null value, the DefaultIfNull formula will return that value.
default_componentsStatFormulaComponentThe formula for the default value to return in case the one in components returns a null value.