Table of Contents
Overview
This Custom Field returns one value from a sequence depending on where the record appears in a group.
Syntax
GROUPSEQUENCE(‘GroupPath‘,’SortField‘,’SequenceList‘)
GROUPSEQUENCE(‘Parent Category:Child Category’,‘Price’,’1:2:3:4‘)
| Element | Description |
|---|---|
| ‘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. |
Example
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 |
| 10.00 | A |
| 15.00 | B |
| 20.00 | A |
| 17.50 | C |
| 19.00 | D |