Help

FILEMAKER PRO HELP 847
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.
Related topics
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
GetFieldName
Purpose
Returns the fully qualified name of a field reference.
Format
GetFieldName(fieldName)
Parameters
fieldName - any field object or evaluation of a text expression that refers to a field’s name
Data type returned
text
Originated in
FileMaker Pro 10.0
Description
Use this function to get the fully qualified name of fieldName (tableName::fieldName).
Note If you specify the context for the current calculation, this function will be evaluated based on
that context. Otherwise, it will be evaluated based on the context of the current window.