U.M. (Windows)

C-14 FileMaker Pro User’s Guide
Logical functions
Syntax Definition
Case (test1, result1 [, test2, result2,
default result]...)
Evaluates test1 to produce a result. When test1 is
true (a nonzero value), returns result1; when test2 is
true, returns result 2, and so on. When no test is true,
returns an empty (null) value, or the default result
you supply.
Choose (test, result0 [, result1,
result2]...)
Evaluates test to produce an index number used to
choose a result. When index is 0, returns result0;
when index is 1, returns result1, and so on. When
there’s no corresponding result, returns an empty
(null) result.
If (test, result one, result two) Evaluates test to return a true or false result. When
test is true (1), returns result one; when test is false
(0), returns result two. Test must return either a
numeric or Boolean result. (See the example below.)
IsEmpty (field) Returns true (1) when field is empty (null);
otherwise returns false (0)
IsValid (field) Returns false (0) when field is missing from the file
or when field contains an invalid value; otherwise
returns true (1). For example, if a field in a related
file is deleted, references to that field in the master
file are invalid. See chapter 10, “Using data from
related files.”