Functions Reference

Chapter 8
|
Logical functions 119
Chapter 8
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, page 120 One of several possible results based on a series of tests.
Choose, page 120 One result value, according to the integer value of a specified test.
Evaluate, page 121 Evaluates the specified expression
as a calculation.
EvaluationError, page
123
An error code, if any, from the specified expression.
GetAsBoolean, page 124 0 if the specified data has a value of 0 or is empty, otherwise returns 1.
GetField, page 124 The contents of the referenced field.
GetLayoutObjectAttribute
, page 125
The requested layout object attributes from the calculation's active window.
GetNthRecord, page 127 The contents of the referenced field from the requested record number.
If, page 129 One of two possible results depending on the value of the specified test.
IsEmpty, page 129 True(1) if the specified field is empty, if the related field, related table,
relationship, or file is missing, or if some other error occurs; otherwise returns
False(0).
IsValid, page 130 0 when a record contains an invalid value because of a data type mismatch
(text in a date field, for example).
IsValidExpression, page
131
True(1) if the syntax of the specified expression is correct.
Let, page 131 Sets variable to the result of value for the duration of the specified
expression.
Lookup, page 133 The value specified in the sourceField parameter using the relationships
in the relationships graph
.
LookupNext, page 134 The value specified in the sourceField parameter using the relationships
in the relationships graph.
Self, page 136 The content of the object in which the calculation is defined, otherwise
returns empty.