FIELDVALUE
Category: Database Function.
Description: Get the field value of a given field of a record provided by ID number.
Syntax: FIELDVALUE(record id number, field code or name, table code or name (optional)).
=FIELDVALUE(Parameter 1, Parameter 2, Parameter 3 (optional))
Parameter 1: Id of the record to load
Parameter 2: Field code or name for which the value should be loaded
Parameter 3: Table dbname or end-user name (optional, if not provided the default table of the current layout will be used)
Example:
=FIELDVALUE(A3,"E1") & " " & FIELDVALUE(A3,"name","t7_n")