Functions Reference

FILEMAKER FUNCTIONS REFERENCE 164
• A field has been deleted from a related table, and therefore the references to that field in the
parent table are invalid
Otherwise, it returns 1 (the data is valid).
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.
Related topics
Contents
Functions reference (alphabetical list)
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
Contents
Functions reference (alphabetical list)