This content has been marked as final. Show 2 replies
ExamplesIsEmpty(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.So there you go. A subtle, yet very important, difference.
Note that either of the two exact match operators can be used to find fields that are empty. To do so, simply search for "=" or "==" and FileMaker will locate records where the field is empty. (Also note that by "empty" we mean really empty. The field cannot have anything in it, not even a single space.)
Want to find fields that are not empty? Either do an omit search for "=" or "==" or do a search using the "*" operator.
Instead of = with an omit request--which will fail if the field is empty due to it being from a related table and there are no related records,
use an * in a regular find request to find all records where the field is not empty.