Prevent Quick Base from Searching Fields

Imagine that you've created an application and included a field to hold some tracking information that you don't want Quick Base to include in certain search operations. For example, say you'd like to know when a record's been created, but that information means little to your application users. To solve a problem like this and to speed searches, a user with administration privileges can exclude certain fields from Quick Base searches.

Understanding Quick Base searches

Quick Base lets you search for data in your application in a number of places:

In each of these areas, you can tell Quick Base you want to find any field with data matching the criteria you specify. In Find, for instance, you simply type in a phrase you want to find. Quick Base automatically searches all fields for your search phrase.

The Searchable Property

Because you may want to speed your searches by excluding certain fields from searches, Quick Base provides a property to set that behavior for each field. By default, this property is turned on for all fields. However, you can turn this property off for any field. When you do so, Quick Base skips over these fields when performing searches that use <Some field> as the search criteria.

Set the Searchable property for one field using field properties:

Set the Searchable property for several fields at one time by selecting the checkmarks on the field list page.

What happens when I search for a particular field?

Even if you've turned off the Searchable property for a particular field, you can still search that field. Whenever you specify a particular field in a search (instead of using <Some field>), Quick Base searches that field even if you've turned off the property for that field.

To exclude one or more fields from <Some field> searches:
  1. From the table containing the field you want to exclude, click SETTINGS in the Page bar, then click Fields.

  2. If the Searchable column does not appear in the Fields list, click the Advanced Options link, select Searchable, and click Save.

  3. Clear the checkmark in the Searchable column for any field you do not want to include in search. 

Related Topics:


Go back      |       

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