Functions Reference

FILEMAKER FUNCTIONS REFERENCE 164
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
Originated in
FileMaker Pro 6.0 or earlier
Description
Case 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 evaluated
return True, the
Case function returns the value specified for defaultResult. If no default result is
supplied,
Case 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 2 when the
Shipment Method field contains Ground, and returns 10 when the Shipment Method field contains
Air.
Related topics
Contents
Functions reference (alphabetical list)
Choose
Purpose
Returns one result value, according to the integer value of test.
Format
Choose(test;result0{;result1;result2...})