Search
⌃K
Links

Array

An overview of 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 Yes (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 concrete items in an array

​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

​length​

To return the count of all characters in a string or all items in 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