0

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

 

contains

To check if a string or an array contains an exact match

 

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

 

index

To return the start position of the first match in a string or 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

Reply

null