Using array functions in Airtable
  • 21 Nov 2022
  • 1 Minute to read
  • Dark
    Light

Using array functions in Airtable

  • Dark
    Light

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, false, 5] when values are [1, 2, false, null, 5]

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]


Was this article helpful?