Functions Reference

Chapter 8
|
Logical functions 123
The Evaluate function has an optional second parameter, which is a field the calculation
is dependent on. When the dependent field contents change, FileMaker Pro re-evaluates
the calculation. In the following example, the Total calculation will be re-evaluated when
SubTotal changes:
Evaluate(StateTaxFormula, SubTotal) + ShippingCost
The dependent parameter can also be useful in other cases. For example,
Evaluate(“Get(CurrentTimeStamp)”, [FieldB, FieldC])
will store a timestamp in the calculation field whenever FieldB or FieldC changes.
EvaluationError
Format
EvaluationError(expression)
Parameter
expression - any calculation expression
Data type returned
number
Description
Returns an error code, if any, from expression. There are two types of errors: syntax
errors and runtime errors. A syntax error indicates an invalid calculation. A runtime error,
such as Field missing or Record missing, occurs when the calculation currently being run
is valid but cannot properly execute. See FileMaker Pro Help for a list of error codes and
messages.
Note The EvaluationError function must enclose the Evaluate function to return any
syntax errors.
Examples
EvaluationError(calculationField) returns 102 (Field Missing) when
calculationField contains total + 1 and the field total has been deleted or renamed.
EvaluationError(Evaluate(calculationField)) returns 1207 (Unbalanced
Parenthesis) when calculationField contains abs(-1 with no closing parenthesis.