IsValidExpression
Purpose 
Returns 1 (True) if expression syntax is correct. Returns 0 (False) if expression has a syntax error.
Format 
IsValidExpression(expression)
Parameters 
expression - any calculation expression
Data type returned 
number
Originated in 
FileMaker Pro 7.0
Examples 
IsValidExpression(calculationField) returns 1 (true) if calculationField contains total + 1.
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
Was this topic helpful? Send feedback.