Grouping data

GROUPSEQUENCE – Display value for record in a sequence

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

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

See also

GROUPNUMBERSEQUENCE

GROUPSEQUENCEONFIELDCHANGE

Was this helpful?