Filemaker Pro 8.5 Educational Maintenance T1 TJ086LL/A Manual Do Utilizador
Códigos do produto
TJ086LL/A
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
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.
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
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
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 [ ].
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
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.
calculation.
Examples
Evaluate(TextField) returns
4
when TextField contains 2 + 2.
Evaluate("textfield") returns
2 + 2
when textfield contains 2 + 2.