Formula Playground
Copy base
Report abuse
Views
Example Text (and Function numbers)
Formula Reference
Description (from Formula Reference)
Type (from Formula Reference)
Example Linked Records
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.

Text functions
apple
Unnamed record
apple
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.

Array functions
apple
Unnamed record
banana
potato
apple
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.

Array functions
apple
apple
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.

Array functions
apple
banana
Drag to adjust the number of frozen columns
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
apple! ! apple
2 - 0 - 1
2.0, 0.0, 1.0
apple, apple
apple, apple
apple, Unnamed record, apple
apple
apple
apple! ! banana! potato! apple
1 - 0 - 4 - 3 - 2
1.0, 0.0, 4.0, 3.0, 2.0
apple, banana, potato, apple
apple, banana, potato, apple
apple, Unnamed record, banana, potato, apple
apple, banana, potato
apple, banana, potato
apple! apple
2 - 1
2.0, 1.0
apple, apple
apple, apple
apple, apple
apple
apple
apple! banana
2 - 4
2.0, 4.0
apple, banana
apple, banana
apple, banana
apple, banana
apple, banana
4 records
  • All — use the below views to filter between examples!
  • Example Records
  • ARRAYJOIN()
  • ARRAYCOMPACT()
  • ARRAYFLATTEN()
  • ARRAYUNIQUE()
Extensions

Alert

Lorem ipsum
Okay