Functions Reference

130 FileMaker Functions Reference
Data type returned
number
Description
Returns True(1) if field is empty, if a related field, related table, relationship, or file is
missing, or if some other error occurs; otherwise returns False(0).
Examples
IsEmpty(OrderNum) returns 1 if the OrderNum field is empty.
If(IsEmpty(LastName);“Invalid record”;““) displays Invalid Record if the
LastName field is blank, but displays nothing if there is an entry in LastName.
IsEmpty(Payments::DatePaid) returns 1 if, for example, the Payments table has
been moved or renamed.
IsEmpty(“text”) returns 0.
IsValid
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).