Welcome to Catalog Tips
Search more than 200 articles to learn more about creating and automating your product catalogs
Tip: Start typing in the input box for immediate search results.
GROUPSEQUENCEONFIELDCHANGE – Return value and reset sequence
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’)