Skip to main content

Array Functions

Array functions allow you to process and transform lists of values.

SIZE(A)​

Returns the number of items in array A.

SIZE( items )

FILTER(A, C)​

Returns a new array containing items from A that match condition C.

FILTER( items, type == "service" )

SORT_ASC(A, F)​

Sorts array A in ascending order based on field F.

SORT_ASC( items, price )

SORT_DESC(A, F)​

Sorts array A in descending order based on field F.

SORT_DESC( items, date )

UNIQUE(A, F)​

Returns a list of unique values from array A based on field F.

UNIQUE( items, team )

GET(A, N)​

Returns the item at position N in array A.

GET( items, 2 )

FIRST(A)​

Returns the first item of array A.

FIRST( items )

LAST(A)​

Returns the last item of array A.

LAST( items )

MAP(A, E)​

Transforms array A into a new array using expression E.

MAP( items, name )

JOIN(A, S)​

Joins items of array A into a single text using separator S.

JOIN( countries, ", " )

Was this article helpful?

Yes
No