This Custom Field returns one value from a sequence depending on where the record appears in a group.
GROUPSEQUENCE(‘Parent Category:Child Category’,‘Price’,’1:2:3:4‘)
|‘GroupPath’||Group path delimited by colons.|
|‘SortField’||The field by which to sort.|
|‘SequenceList’||Colon delimited sequence list.|
|‘FieldName’||Optional field name – TRUE to include record in sequence.|
Each record in the nominated group will receive the next value from a given list of values.
GROUPSEQUENCE(‘Parent Category:Child Category’,‘GST Inc Price’, ‘A:B:C:D’)
This function will evaluate to ‘A’ for the first record in the Child Category group; ‘B’ for the second, etc. Once all values in the list have been exhausted, EasyCatalog will continue with the first, second, etc.
|GST Inc Price||GROUPSEQUENCE|