How to Filter and Search Your Locations Database
As your database grows, searching for specific locations can be streamlined using filters. This guide will walk you through filtering your location database by capacity, city, region, and more, along with exporting results to Excel.
Table of Contents
Using Search Filters
Understanding Filter Options
Deleting Search Items
Exporting Filtered Results
1. Using Search Filters
Go to the Locations module.
Next to the search field, click the grey circle with the three dots.
Clicking this will add the Select a field button.
Click Select a field to choose your filter criteria. You can continue adding multiple filters as needed.
For example, you can filter locations by city or capacity.
2. Understanding Filter Options
For fields with letters:
= indicates it will search for your exact entry.
!= means it will exclude your entry.
For fields with numbers:
= searches for the exact number.
> finds entries larger than your number.
< finds entries smaller than your number.
3. Deleting Search Items
To delete a filter, hover your mouse over the search field you want to remove. A bin icon will appear. Click on it to delete the filter.
4. Exporting Filtered Results
If needed, you can export your filtered results to Excel for further analysis.
Next to the search bar, click the three vertical dots (not the one in the circle).
Select Export selection… from the dropdown.
An Excel file named list.xlsx (or with numbers like list(1).xlsx) will begin downloading. You can open this file in Excel or Numbers.