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.

< All Topics
Print

GROUPXREFFIELD – Find name of field based on matching record

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

Table of Contents