An array is a combination of values that are typically separated by a comma. In Airtable, arrays can be used to produce this type of list when used in conjunction with a rollup or lookup field.
The array functions listed below are only able to be used within the rollup field.
| Function |
Description |
Examples |
|
ARRAYCOMPACT(values)
|
Removes empty strings and null values from the array. Keeps "false" and strings that contain one or more blank characters. |
ARRAYCOMPACT(values)
=> [1,2,3,false," "] when values are [1,2,"",null,false," "]
|
|
ARRAYFLATTEN(values)
|
Flattens the array by removing any array nesting. All items become elements of a single array. Use when you have a lookup of a lookup for example. |
ARRAYFLATTEN(values)
=> [1,2,3,false] when values are [[1,2,"",3],[false]]
|
|
ARRAYJOIN(values, separator)
|
Join the array of rollup items into a string with a separator. Used when formulas can't be achieved on array data types and must be converted to a string first. |
ARRAYJOIN(values, "; ")
=> 1; 2; 3 when values are [1,2,3]
|
|
ARRAYUNIQUE(values)
|
Returns only unique items in the array. |
ARRAYUNIQUE(values)
=> "[1,2,3]" when values are [1,2,3,3,2,1]
|