IsEmpty
Purpose
Returns 1 (true) if a field is empty or if other errors occur; otherwise, returns 0 (false).
Format
IsEmpty(field)
Parameters
field - any
field name,
text expression, or numeric expression
Data type returned
number
Originated in
FileMaker Pro 6.0 or earlier
Description
This function returns 1 (true) if a field is empty, if a related field, a related table, relationship, or a file is missing, or if another error occurs; otherwise, 0 (false).
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.
Related topics