On This Page
> resources > docs > expressions > Null Handling Functions

Null Handling Functions

Functions for working with null or missing values.

Understanding Null Values

In ProcessMind, null represents missing or undefined data. This can occur when:

  • A field is empty in the source data
  • A calculation resulted in an undefined value (e.g., division by zero)
  • A lookup or reference couldn’t find a match

Null handling functions help you work with these cases gracefully.

Common Patterns

  • Provide a Default Value:

    ifNull(Department, "Unassigned")

  • Check Multiple Fields for Values:

    coalesce(PreferredName, FirstName, "Guest")

  • Filter Out Placeholder Values:

    nullIf(Status, "N/A")    // Returns null if Status is "N/A"

  • Conditional Logic on Null:

    if(isNull(Manager), "Self-managed", Manager)

isNull

(value)

Checks whether a value is null.

Parameters
value any The value to check
Returns boolean
Examples
isNull(Department) → true if Department is null
isNull(null) → true
isNull("value") → false
See Also
isNotNullifNullcoalesce

isNotNull

(value)

Checks whether a value is not null.

Parameters
value any The value to check
Returns boolean
Examples
isNotNull(Department) → true if Department has a value
isNotNull(null) → false
isNotNull("value") → true
See Also
isNullifNull

ifNull

(value, fallback)

Returns the first value when it is not null; otherwise, returns the fallback value.

Parameters
value any The value to check
fallback any The value to return if null
Returns any
Examples
ifNull(Department, "Unknown") → Department value or "Unknown"
ifNull(null, "default") → default
ifNull("value", "default") → value
See Also
coalesceisNull

coalesce

(value1, value2, ...?)

Returns the first non-null value from a list of values.

Parameters
value1 any First value
value2 any Second value
... (optional) any Additional values, up to 6 total
Returns any
Examples
coalesce(PreferredName, FirstName, "Guest") → First non-null value
coalesce(null, null, "fallback") → fallback
coalesce("first", "second") → first
See Also
ifNull

nullIf

(value1, value2)

Returns null when two values are equal; otherwise, returns the first value.

Parameters
value1 any The value to return
value2 any The value to compare against
Returns any
Examples
nullIf(Status, "N/A") → null if Status is "N/A"

Useful for replacing placeholder values with null

nullIf("value", "N/A") → value
nullIf("N/A", "N/A") → null
See Also
ifNullcoalesce

Related Documentation