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 Advanced returns a 1; if the condition is false, FileMaker Pro Advanced 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 test. | |
Evaluates an expression as a calculation. | |
An error code, if any, from an expression. | |
Executes an SQL query statement for the specified table occurrence in a FileMaker Pro Advanced file. | |
1 (true) if data converts to a non-zero numeric value or if a container field holds data; otherwise, returns 0 (false). | |
The setting of the specified attribute for the audio, video, or image file in a container field. | |
Evaluates fieldName and returns the contents of the specified field. | |
The fully qualified name of a field reference. | |
The specified attributes of the layout object given by the objectName currently active in the calculation. | |
The contents of fieldName from the specified record number. | |
result1 if the test is true; returns result2 if the test is false. | |
1 (true) if a field is empty or other errors occur; otherwise, returns 0 (false). | |
0 (false) if the data is invalid; otherwise, returns 1 (true). | |
1 (true) if an expression syntax is correct; otherwise, returns 0 (false). | |
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. | |
The value specified in | |
The next lower or higher value in | |
The content of the object in which the calculation is defined. |