Functions Reference

Chapter 8
|
Logical functions 131
Examples
IsValid(Datefield) returns 0 if there is non-date data in Datefield, for example if text
was imported into it.
IsValid(Amount) returns 0 if there is only text in the number field Amount.
IsValid(table::field) returns 0 if the related table was renamed and the
relationship isn’t updated with the new filename.
IsValidExpression
Format
IsValidExpression(expression)
Parameter
expression - any calculation expression
Data type returned
number
Description
Returns True (1) if expression syntax is correct. Returns False (0) if expression has
a syntax error.
Examples
IsValidExpression(calculationField) returns 1 (true) when
calculationField contains total + 1.
IsValidExpression(calculationField) returns 0 (false) when
calculationField contains abs(-1 with no closing parenthesis.
Let
Format
Let({[}var1=expression1{;var2=expression2...]};calculation)
Parameters
var - any variable name, local variable name, or global variable name (see FileMaker Pro
Help for guidelines on naming variables)
expression - any calculation expression, field, or constant
calculation - any calculation expression, field, or constant
Parameters in curly braces { } are optional.