Functions Reference

Chapter 8
|
Logical functions 129
Data type returned
text, number, date, time, timestamp, container
Description
Returns one result value, according to the integer value of test. FileMaker Pro
evaluates test to obtain an index number, which is used to choose the corresponding
ordinal result.
Because the Choose function is a 0 based list, the first item on the list is indexed 0 and
the second item on the list is indexed 1. For example, if test evaluates to 2, then result2
is chosen.
Example
Choose(Rating;“Not Applicable”;“Good”;“Fair”;“Poor”)
Rating is a number field that is empty or holds a value between 1 and 3. If Rating is empty,
the Choose function returns nothing. If Rating is 1, the result is Good. If Rating is 2, the
result is Fair, and if it is 3, the result is Poor.
Evaluate
Format
Evaluate(expression{;[field1;field2;field3;...]})
Parameters
expression - any text expression or text field.
fields - a list of fields that this function is dependent on. When these fields are modified,
the calculation will update its result.
Parameters in curly braces { } are optional. Notice that the optional field list is enclosed in
square brackets [ ].
Data type returned
text, number, date, time, timestamp, container
Description
Evaluates expression as a calculation.
The optional fields parameter is a list of fields this calculation is dependent on. If a
necessary field isn’t listed, modifying that dependent field won’t update the result of the
calculation.
Examples
Evaluate(TextField) returns 4 when TextField contains 2 + 2.
Evaluate("textfield") returns 2 + 2 when textfield contains 2 + 2.