Home > Reference > Functions reference > 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
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.

Related topics 

About functions

About formulas