Functions Reference

FILEMAKER FUNCTIONS REFERENCE 170
Description
Returns a Boolean value.
Examples
GetAsBoolean(“”) returns 0.
GetAsBoolean(“Some text here.”) returns 0.
GetAsBoolean(Container Field) returns 1 when the field named Container Field contains
data, or returns 0 when Container Field is empty.
Related topics
Contents
Functions reference (alphabetical list)
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.