Formula Playground
Copy base
Report abuse
Views
Example Text (and Function numbers)
Formula Reference
1
1
ARRAYJOIN()
2
2
ARRAYCOMPACT()
3
3
ARRAYFLATTEN()
4
4
ARRAYUNIQUE()
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
Description (from Formula Reference)
Text functions

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.

Array functions

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

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

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.

4 records
  • All — use the below views to filter between examples!
  • Example Records
  • ARRAYJOIN()
  • ARRAYCOMPACT()
  • ARRAYFLATTEN()
  • ARRAYUNIQUE()
Extensions

Alert

Lorem ipsum
Okay