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
Was this topic helpful? Send feedback.