The Quick Search bar is located at the top of every list view screen:
- Navigate to the desired module (e.g. Menu > CRM & Sales > Contacts).
- Enter keywords or operators for your search.
Note: To display all records, leave the search fields blank. - Click the search Search icon (
).
).To quickly remove all search terms, click the Clear Search Criteria button (
) at the left of the search bar.
By default, FileMaker searching focuses on initial letters and numbers. To search for records using information from the middle or end of a data point, start your search term with an asterisk (*). For example, to find all contacts with last names ending in "ssen" you would search for "*ssen".
Additional Search Actions
Next to the Search icon, a drop-down menu provides you with additional options:
After completing an initial search, you can refine the results further:
- Search & add to current list — Queries the database for new search criteria and includes any matching records with the current list.
- Search current list — Refines the current records to show only the items that match the new criteria.
- Omit from current list — Refines the current records to remove any items that match the new criteria.
Note: This option is useful for filtering to show all records that do not have a value. For example, typing an asterisk (*) in the Phone column, then selecting the omit option will display all records that do not have a phone number. - Go to Advanced Search — Displays the Advanced Search screen.