IsValidExpression

Returns 1 (true) if an expression syntax is correct; otherwise, returns 0 (false).

Format 

Parameters 

expression - any calculation expression

Data type returned 

number

Originated in 

FileMaker Pro 7.0

Example 1 

IsValidExpression(calculationField) returns 1 (true) if calculationField contains total + 1.

Example 2 

IsValidExpression(calculationField) returns 0 (false) if calculationField contains abs(-1 with no closing parenthesis.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas