Functions Reference

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 (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.
Data type returned
text, number, date, time, timestamp, container
Description
Sets varX to the result of expressionX for the duration of calculation. Multiple
variables are allowed when using a list syntax that is enclosed in square brackets [ ] and
is separated by semicolons. For example:
Let([variable=value;variable2=value2];calculation)
The $ symbol references a local variable and two $$ symbols reference a global variable.
An optional repetition number appears in square brackets [ ] immediately after the variable
name. For example:
Let([$variable[repetition]=value;$$variable2=value2]{;calculation
} )