Miscellaneous utilities

XREFFIELD – Return value of field from another record

106 views June 1, 2018 admin 0

Overview

This Custom Field searches the data source for a record whose field content matches a given value, and will return the value of another field for the found record. It returns the first instance found.

Syntax

XREFFIELD(‘SearchField‘,SearchValue,ReturnField,DataSource)

XREFFIELD(‘PartNo‘,FIELDSTR(‘XRefPartNo’),’Page‘)

Element String
SearchField The name of the field to search in.
SearchValue The value to search for in the ‘Search Field’
ReturnField The name of the field to return from the matching record.
DataSource The name of another EasyCatalog data source to search within. This option applies to the Search Field and Return Field parameters; the Search Value will be retrieved from fields in the current data source. This is an optional element.

Example

XREFFIELD(‘PartNo‘,FIELDSTR(‘XRefPartNo’),’Page‘,Parts.txt)

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.

PartDescriptions.txt

XRefPartNo Description Page
A1 Door handle 1
B1 Hinge 1
B2 Phillips Head Screw 2

Parts.txt

PartNo Page
A1 1
B1 1
B2 2

See also

Was this helpful?