IsValid function

IsValid function

Format


IsValid(field)

Parameter

field - any field name

Data type returned

number

Description

Returns False (0) when:

A record contains an invalid value because of a data type mismatch (text in a date field, for example)

FileMaker Pro cannot locate (temporarily or permanently) the related table in which the referenced field is defined

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

Functions reference (category list)