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

    Using array functions in Airtable

    • Updated on 21 Nov 2022
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article Summary

    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.

    FunctionDescriptionExamples

    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?
    What's Next