Additional Functions for Formulas

`case`

Use a case statement to handle if/then logic. A case statement always has a pair of where and then statements.

case [primary_expr]
    when condition
    then result_expression
    else 
        default_expression
end

primary_expression—Optional. Any valid expression to compare against a set of expressions. The primary expression is compared to the expression in each when clause for equivalency. If these expressions are equivalent, the expression in the then clause will be returned.
condition—The condition of a case statement can take two forms:
- An expression that is compared against a set of possible values.
- A boolean expression that evaluates to true, false, or null.
result_expression—The expression returned when the primary_expression satisfies the condition and evaluates to True.
default_expression—If neither of the previous comparisons evaluate to True, this expression is returned.

case ShippingState__c
    when 'CA'
    then 'California'
    else 
        'Other'
end

case 
    when "ShippingState__c" = 'CA'
    then 'California'
    else 
        'Other'
end

Use the coalesce function as shorthand for case statements. This function replaces null values with another value.

coalesce(expression1, expression2)

coalesce(city, null)

Returns the first non-null value. If there isn’t one, then the function returns null.

Use the sequence function to create a sequence of numbers or dates by defining the start and end values and the interval between each value.

sequence(start,stop,step)

sequence(start_field, stop_field, interval 1 day)

Returns an array with one element for each value.

Use the uuid function to generate a unique identifier for rows in a table.

uuid()

Returns a 36-character, universally unique identifier string for each row in a table.