Functions Reference

124 FileMaker Functions Reference
GetAsBoolean
Format
GetAsBoolean(data)
Parameter
data - any text, number, date, time, timestamp or container expression, or a field
containing text, a number, date, time, timestamp or container.
Data type returned
number
Description
Returns 0 if data has a value of 0 or is empty, all other values return 1.
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.
GetField
Format
GetField(fieldName)
Parameter
fieldName - any text expression
or text field that refers to a field’s name
Important See Design functions, page 35 for information about literal text parameters.
Data type returned
text, number, date, time, timestamp, container
Description
Returns the contents of fieldName. Use this function to get fieldName’s contents, or
in any function that uses a field, such as NPV, GetSummary, GetRepetition, or the
aggregate functions.