Functions Reference

FILEMAKER FUNCTIONS REFERENCE 178
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
Contents
Functions reference (alphabetical list)
Let
Purpose
Sets varX to the result of expressionX for the duration of calculation, until the script exits (local
variables), or until the file is closed (global variables).
Format
Let({[}var1=expression1{;var2=expression2...]};calculation)
Parameters
var - any variable name, local variable name, or global variable name(see About naming fields 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
Originated in
FileMaker Pro 7.0