Search…
Array
An overview over the array functions

​array​

To create a new array by merging 2 arrays of a similar type

​avg​

To return the average of a number array

​chosen​

To return "true" if the given value equals a given selection

​concat​

To return all items of an array in one string

​count (aka cnt)

To return the number of items in an array or a selection of records

​files​

To return all attachments of a record as an array

​first​

To return the first item of an array

​item​

To extract a value of an array or an object

​join​

To return a string consisting of all items of the given string array separated by a given separator

​last​

To return the last item of an array

​max​

To return the highest or latest value of an array

​min​

To return the lowest or earliest value of an array

​numbers​

To return the IDs of the selected choice values of a given multiple choice field

​range​

To return an array of consecutive numbers

​rsort​

To sort an array in descending order

​slice​

To extract a subrange from a string or array

​sort​

To sort values in ascending order

​split​

To split a string into an array at each separator

​splitx​

To split a string into an array by using a regular expression

​sum​

To return the total sum of a number array

​unique​

To return an array with unique elements