Example Text (and Function numbers)
Formula Reference
Description (from Formula Reference)
1
1
ARRAYJOIN()

Join the array of items into a string with a separator.

Note that array functions can only be used when the values are first aggregated by a rollup field or when the input field is a lookup.

2
2
ARRAYCOMPACT()

Removes empty strings and null values from the array. Keeps "false" and strings that contain one or more blank characters.

Note that array functions can only be used when the values are first aggregated by a rollup field or when the input field is a lookup.

3
3
ARRAYFLATTEN()

Flattens the array by removing any array nesting. All items become elements of a single array.

Note that array functions can only be used when the values are first aggregated by a rollup field or when the input field is a lookup.

4
4
ARRAYUNIQUE()

Returns only unique items in the array.

Note that array functions can only be used when the values are first aggregated by a rollup field or when the input field is a lookup.

Cannot adjust frozen columns; click to learn more or reset
Type (from Formula Reference)
Example Linked Records
ARRAYJOIN([item1, item2, item3], separator)
ARRAYJOIN()—Example 2 w/ lookup
Example Numbers (from Example Records)
ARRAYCOMPACT()—Example 2 w/ lookup
ARRAYCOMPACT([item1, item2, item3])
ARRAYFLATTEN([item1, item2, item3])
ARRAYUNIQUE([item1, item2, item3])
ARRAYUNIQUE()—Example 2 w/ lookup
Text functions
apple
Unnamed record
apple
apple! ! apple
Array functions
apple
Unnamed record
banana
potato
apple
apple! ! banana! potato! apple
Array functions
apple
apple
apple! apple
Array functions
apple
banana
apple! banana
4 records
Extensions

Alert

Lorem ipsum
Okay