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 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 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 if it isn't null; otherwise, returns the fallback value.

Parameters
value any Value to check
fallback any 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 in a list.

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 if two values are equal; otherwise, returns the first value.

Parameters
value1 any Value to return
value2 any 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

Design better processes. Build a connected architecture. Stay in control.

Get instant access with no credit card and no waiting. Turn the way your organization works into clear, connected process designs.

Build your process architecture, define ownership and controls, and align roles and responsibilities across every level.

Start your free trial and create one reliable foundation for governing, managing, and continuously improving your processes.

Get Your Free Trial Today