Grouping data

GROUPSEQUENCEONFIELDCHANGE – Return value and reset sequence

114 views June 1, 2018 July 26, 2018 admin 0

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’)

See also

GROUPSEQUENCE

GROUPNUMBERSEQUENCE

Was this helpful?