Reference > Functions reference > Logical functions > IsEmpty
 
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 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas