Advanced Tools
Find Empty Fields
Perform a search for an empty checkbox or radio button.
-
Use to find Contacts with a last name, email address, etc.
-
Use to find if any Work Orders are neither hold, complete or incomplete.
How to Find an Empty Field
-
In any Find screen, enter an equal sign = in the field you wish to find empty.
-
Click the Perform Find button.
-
The search results appear. Since we added nothing after the equal sign, FileMaker Pro searches for records with an empty field.
How to Find an Empty Checkbox or Radio Button
-
In any Find screen, right-click the checkbox or radio button.
-
Click Operators and choose the = (equal sign).
-
Even though nothing appears to have changed, click the Perform Find button.
-
The search results appear.
