Grouping data

GROUPXREFFIELD – Find name of field based on matching record

34 views June 1, 2018 admin 0

Overview

This Custom Field searches within each group for a record whose field content matches a given value, and will return the value of another field for the found record.

Syntax

GROUPXREFFIELD(‘GroupPath’,‘SortField’,’SearchValue’,‘ReturnField’)

GROUPXREFFIELD(‘Parent Category:Child Category’,‘PartNo’,FIELDSTR(‘XRefPartNo’),‘Page’)

Element Description
GroupPath The group path, delimited by colons.
SearchField The field to search.
SearchValue The value to search for within the search field.
ReturnField The name of the field to return from the matching record.

Example

GROUPXREFFIELD(‘Parent Category:Child Category’,‘PartNo’,FIELDSTR(‘XRefPartNo’),‘Page’)

This example will search for a record whose ‘PartNo’ field contains the value of this record’s ‘XRefPartNo’ field. When one is found, the contents of its ‘Page’ field will be returned. In contrast to XREFFIELD , this Custom Field only searches within each group (not the entire data source).

See also

XREFFIELD

Was this helpful?