Functions Reference

120 FileMaker Functions Reference
Case
Format
Case(test1;result1{;test2;result2;...;defaultResult})
Parameters
test - any text or numeric expression.
result - result corresponding to the expression.
Parameters in curly braces { } are optional.
Data type returned
text, number, date, time, timestamp, container
Description
Returns one of several possible results based on a series of tests.
The Case function evaluates each test expression in order, and when a True expression
is found, returns the value specified in result for that expression.
You can include a default result at the end of the parameter list. If none of the expressions
evaluate to True, the Case function returns the value specified for defaultResult. If no
default result is supplied, the Case function returns an “empty” result.
Examples
Case(Score >= 90;“Excellent”;Score > 50;“Satisfactory”;“Needs
Improvement”) displays Excellent when the score is 90 or above, Satisfactory when
the score is between 50 and 90, and Needs Improvement for any other score.
Case(Shipment Method=”Ground”;2;Shipment Method=”Air”;10) returns 10,
when the Shipment Method field contains Air.
Choose
Format
Choose(test;result0{;result1;result2...})
Parameters
test - Any integer calculation. The calculation result of test must be a number that
indexes
into the list that follows. Because the index is a 0 based index, the test result must
be 0 to access the first result.
result - one or more results.
Parameters in curly braces { } are optional.