Table of Contents
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).