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