Table of Contents
Overview
This Custom Field populates a group with a numerical series that increments each time a given field changes value. It resets the sequence when the field has content.
Syntax
GROUPSEQUENCEONFIELDCHANGE(‘GroupPath’,‘SortField’,‘SequenceList’, ‘FieldName’)
GROUPSEQUENCEONFIELDCHANGE(‘Parent Category:Child Category’,‘Price’,‘black:white’, ‘Heading’)
| Element | Description |
|---|---|
| ‘GroupPath’ | Group path delimited by colons. |
| ‘SortField’ | The field by which to sort. |
| ‘SequenceList’ | Colon delimited sequence list. |
| ‘Heading’ | Field name. The sequence is reset if this field is not blank. |
Example
GROUPSEQUENCEONFIELDCHANGE(‘Parent Category:Child Category’, ‘black:white’, ‘Heading’)