Advanced search lets you home in on just those records in a table you want to see. Use this feature to display only those items that meet a set of criteria you specify. For example, say you only wanted to view tasks that are assigned to you. Or maybe you'd like to see which clients live in Alaska. You can even combine criteria to, for instance, find tasks that are both assigned to you and overdue.
To use advanced search on a table:
-
Open a table from the sidebar, then select Search on the global bar.
Note: If you don't see this button, your app admin has removed access to it.
-
Select Advanced Search.
-
Enter the filter criteria for your search to specify which records you want to see, then click Search. Quickbase shows you a report with set of records containing the term you entered. If you don't get the results you wanted, customize the report by selecting the edit icon.
You can also save the report for future use.
To save your search results as a report:
-
Select the More actions menu
on the page bar and choose Save report as.
-
Enter a name for the report.
Optionally, enter a description for the report, then click Show description on report page if you want the description to appear on the report.
-
Select the visibility of the report:
-
Personal – Only you can view this report.
-
Common – Others can view this report.
-
-
For common reports, select an option from the May be viewed by dropdown. If you chose Specific Roles, select the checkbox next to one or more of the roles in the list.
-
Click OK to save the report.
To set your table home page to use advanced search:
If you'd like to provide advanced search capabilities to your end users, you can specify that the table home page they see will display the advanced search form.
-
Open the table Home page settings. You can do this in one of the following ways:
-
If you have clicked the table to display the table Home page, click the Customize this Page link on the page bar.
-
In the sidebar, select a table. Click Settings on the page bar, then click Table home page in the User Interface section.
-
-
Next to each role, choose Advanced Search form from the dropdown in the View column.