Logical functions

Contents > Functions reference (alphabetical list) > Logical functions

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

One of several possible results based on a series of tests.

One result value, according to the integer value of a specified test.

Evaluates the specified expression as a calculation.

EvaluationError

An error code, if any, from the specified expression.

0 if the specified data has a value of 0 or is empty, otherwise returns 1.

The contents of the referenced field.

GetLayoutObjectAttribute

The requested layout object attributes from the calculation's active window.

The contents of the referenced field from the requested record number.

If

One of two possible results depending on the value of the specified test.

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).

0 when a record contains an invalid value because of a data type mismatch (text in a date field, for example).

IsValidExpression

True(1) if the syntax of the specified expression is correct.

Let

Sets variable to the result of value for the duration of the specified expression.

The value specified in the sourceField parameter using the relationships in the relationships graph.

The value specified in the sourceField parameter using the relationships in the relationships graph.

The content of the object in which the calculation is defined, otherwise returns empty.

Contents > Functions reference (alphabetical list) > Logical functions