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] |