Calculates the number of text, number, or time-date values in a list. This function always returns a number to indicate the number of entries in the list.
@Elements( list )
list
Text list, number list, or time-date list.
numElements
Number. The number of elements in the list. If the field value is a null string, @Elements(list) returns the number 0. @Count returns 1 if the field value is a null string or not a list value.
You can use @Elements in the condition statement of @For functions to set the loop count equal to the number of elements in the list:
@For(n := 1; n <= @Elements(list); n := n + 1;formula)
@Elements(SalesForce)
@Elements("Jones":"Portsmore")
3 + @Elements("Liston":"Reed")
@For(n := 1;n <= @Elements(dogs); n := n+1;
FIELD concat := @If(n = 1;love[n] + dogs[n];concat : (love[n] + dogs[n])));
concat
The result of this formula is: I love Poodles;I love Huskies;I love Corgis.