Improving Global App Search

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.

Which fields are searched by global app search?

Global app search will search fields marked Searchable that your role has access to. Field types are set to searchable by default depending on the field type. The built-in fields Date Created, Date Modified, and Record ID# are also set to not be searched by default. Read more about the Searchable property.

Why don't I see my search term in the results?

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.

Why is global app search sometimes slow?

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:

  • Many records (tens of thousands)
  • Hundreds or thousands of fields in each table (especially if many of those fields are text fields)
  • Lots of data stored in text or formula fields

Optimizing global app search for your users

Try some of these techniques to improve the search experience for your users:

  • Try table search
  • Try exact search
  • Create targeted reports
  • Create custom search widgets
  • Archive some data
  • Hide fields and tables from some roles

Each of these techniques is described below.

Try table search

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

Try exact 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.

Create targeted reports

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.

Create custom search widgets

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.

Archive data

If your tables are very large or contain historical data, try archiving some of that unused data – that way there's less to search.

Hide fields and tables

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.

Related Topics:

 

Go back      |       

© 1999-2019  QuickBase, Inc.  All rights reserved.  Legal Notices.