Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to put a list of Distinct field values into a variable array?
I am trying to create a nested For each next loops where the loops loop through each distinct field value.
May be do this with FieldValue() and FieldValueCount() function
For i = 1 to FieldValueCount('FieldName')
LET vVar = $(vVar) & FieldValue('FieldName', $(i));
NEXT i
Something along these lines
May be do this with FieldValue() and FieldValueCount() function
For i = 1 to FieldValueCount('FieldName')
LET vVar = $(vVar) & FieldValue('FieldName', $(i));
NEXT i
Something along these lines