Functions Reference

Logical functions
F
ILEMAKER FUNCTIONS REFERENCE 238
GetField
Purpose
Evaluates fieldName and returns the contents of the specified field.
Format
GetField(fieldName)
Parameters
fieldName - any text expression or text field that refers to a field’s name
Important See Design functions for information about literal text parameters.
Data type returned
text, number, date, time, timestamp, container
Originated in
FileMaker Pro 6.0 or earlier
Description
GetField evaluates fieldName, matches the result to a field in the table on which the calculation
was performed, and returns the contents of that field.
To return values of fields that have the same field name across multiple tables, enclose fieldName
in double quotation marks, as in
GetField("fieldName").
For example, GetField("Phone") returns a value from Customer::Phone when GetField is
calculated on the Customer table, and returns Company::Phone when GetField is calculated on the
Company table.
To return the values of multiple fields, do not enclose fieldName in quotation marks, as in
GetField(fieldName), and specify a field that contains a value that matches the name of
another field in the table. To change the value that GetField returns, change the value in the
specified field to match the name of a different field in the table.
For example, a table has three fields: Customer::ContactMethod, Customer::Phone, and
Customer::Email. When Customer::ContactMethod contains “Phone”,
GetField(ContactMethod) returns the contents of Customer::Phone. However, when
Customer::ContactMethod contains “Email”,
GetField(ContactMethod) returns the contents of
Customer::Email.