Functions Reference

Logical functions
F
ILEMAKER FUNCTIONS REFERENCE 224
GetField
Purpose
Returns the contents of fieldName.
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
Use this function to get the contents of fieldName, or in any function that uses a field, such as NPV,
GetSummary, GetRepetition, or the aggregate functions.
Examples
Suppose you have the fields Arrow and Target. Arrow contains the text string Target, and Target
contains the text string Bullseye.
• GetField(“Arrow”) returns Target. Notice the use of quotation marks around Arrow to
indicate the literal string is the
fieldName parameter.
• GetField(Arrow) returns Bullseye. Notice the absence of quotation marks to indicate
the value stored in the Arrow field is the
fieldName parameter.
Suppose you have the fields FirstName and LastName. FirstName contains the text string Jane,
and LastName contains the text string Public.
• GetField(“FirstName”)&“ ”&GetField(“LastName”) returns the text string Jane
Public.
GetSummary(GetField(“Field1”), GetField(“Field” & “2”)) performs a summary on
the
summary field Field1, using a break field of Field2.