Functions Reference

Logical functions
F
ILEMAKER FUNCTIONS REFERENCE 226
Logical functions
Logical functions test for a condition to evaluate it as true or false. This is known as a Boolean value.
If the condition is true, FileMaker Pro returns a 1; if the condition is false, FileMaker Pro returns a 0.
You can use the keywords
True and False with logical functions and operators when a Boolean
value is needed. Keyword
True returns 1 and keyword False returns 0.
Logical functions can also evaluate parameters such as text or arithmetic operations that do not
make a true or false statement, or in the case of the
GetField function, return the contents of
another
field.
Click a function name for details.
This function Returns
Case One of several possible results based on a series of tests.
Choose One result value, according to the integer value of a test.
Evaluate Evaluates an expression as a calculation.
EvaluationError An error code, if any, from an expression.
ExecuteSQL Executes an SQL query statement for the specified table occurrence in a
FileMaker
Pro file.
GetAsBoolean 1 (true) if data converts to a non-zero numeric value or if a container field
holds data; otherwise, returns 0 (false).
GetAVPlayerAttribute The setting of the specified attribute for the audio, video, or image file in a
container field.
GetField Evaluates fieldName and returns the contents of the specified field.
GetFieldName The fully qualified name of a field reference.
GetLayoutObjectAttribute The specified attributes of the layout object given by the objectName
currently active in the calculation.
GetNthRecord The contents of fieldName from the specified record number.
If Either result1 or result2, depending on the value of a test.
IsEmpty 1 (true) if a field is empty or other errors occur; otherwise, returns 0 (false).
IsValid 0 (false) if the data is invalid; otherwise, returns 1 (true).
IsValidExpression 1 (true) if an expression syntax is correct; otherwise, returns 0 (false).
Let The result of a variable or variables set to the result of the specified
expression(s) for the duration of the calculation, or until the script exits or the
file is closed.
Lookup The value specified in sourceField, using the relationships in the relationships
graph.
LookupNext The next lower or higher value in sourceField when there isn’t a matching
related value.
Self The content of the object in which the calculation is defined.