Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Chapter 8

  

|

  Logical functions     129

text, number, date, time, timestamp, container

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.

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 

. If Rating is 2, the 

result is 

, and if it is 3, the result is 

.

Evaluate(expression{;[field1;field2;field3;...]})

expression - any 

 or text 

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 [ ].

text, number, date, time, timestamp, container

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.

Evaluate(TextField) returns 

when TextField contains 2 + 2.

Evaluate("textfield") returns 

 when textfield contains 2 + 2.