April 23, 2026

Array functions in custom formulas

Custom formulas now include a dedicated set of array functions for working with list values:

Function	Description
`array_contains(array, value)`	Returns true if the array contains the given value.
`array_length(array)`	Returns the number of elements in the array.
`array_to_string(array, delimiter)`	Joins the elements of the array into a string with the given delimiter.
`array_get(array, index)`	Returns the element at the given position (1-based index).
`array_any(array1, array2)`	Returns true if the two arrays share any common element.
`array_all(array1, array2)`	Returns true if all elements of the second array are present in the first.
`array_intersect(array1, array2)`	Returns an array of elements present in both arrays.
`array_union(array1, array2)`	Returns an array of unique elements from both arrays combined.
`array_diff(array1, array2)`	Returns elements from the first array that are not in the second.