Global app search is accessible from the Search button on the Global bar. If you are on an app's home page, clicking Search will display a dropdown that lets you enter a search term. Searching from this location will search the entire app.
Global app search will search fields marked Searchable that your role has access to. Some field types are not searchable by default: the built-in Date/Time fields Date Created and Date Modified, as well as iCal and vCard fields.
The search results are displayed using the default report for each table. Sometimes the default report doesn't include the field that contains your search term.
Global app search is equivalent to searching for <Some field> contains My_search_term in every table in the app. By default, the search must look at the contents of every field in every record in every table to return results.
Instead, you can set the default behavior for global search within an app to Match the search term exactly, rather than match any terms that contain the typed value. In the app settings area, go to App properties, then look for Performance options in the Advanced settings area of the page, and select the Match the search term exactly checkbox.
If you do set the default to Global searches in this app default to Match search term exactly, users will still have a option to clear the Match search term exactly checkbox and search instead for a value containing the value that they type.
A <Some field> contains My_search_term global search may be slower if your tables have some combination of these three factors:
Try some of these techniques to improve the search experience for your users:
Each of these techniques is described below.
First of all, recommend that your app users try the table search functionality before running global app searches.
|try a table search...||instead of an app search|
Recommend that your app users select Match search term exactly on the search dropdown, for app search and table search. When this checkbox is selected, the search changes to <Some field> is equal to My_search_term. This type of search is generally faster than a contains search.
Next, investigate what your app users most commonly search for, and create "ask the user" filters or targeted reports that will handle those searches. You can use all the usual techniques of creating reports to narrow the amount of data that will be searched.
Hide the Search button on the Global bar for most roles. Create custom search widgets on the app home page so that your app users can perform targeted searches.
Search widgets will perform a contains search by default, but they can be configured to look for the exact search term entered instead. Using Match search term exactly causes your searches to be faster because it is not a a contains search.
If your tables are very large or contain historical data, try archiving some of that unused data – that way there's less to search.
If your users still choose to use the global app search, here are some techniques for improving the experience:
Unset the Searchable property on fields/tables that you don't want to search. Learn more.
Fields that tend to cause performance issues include Text fields (especially Text - Multi-line with log entries turned on, and formula fields).
Use role settings to hide very large tables from roles that tend to do a lot of searching.
Return to top
© 1999-2017 QuickBase, Inc. All rights reserved. Legal Notices.
Show help contents