Prevent QuickBase from Searching Fields

Imagine that you've created an application and included a field to hold some tracking information that you don't want QuickBase 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 QuickBase searches.

Understanding QuickBase searches

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

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

In Advanced find, you can select <Some field> as your search criteria.  Filtering on <Some field> tells QuickBase to include in the report any field with data matching the criteria you specify.

howsearchworks.png

The Searchable Property

Because you may want to speed your searches by excluding certain fields from searches, QuickBase 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, QuickBase skips over these fields when performing Quick Find searches and any other search that uses <Some field> as the search criteria.

Set the Searchable property for one field using field properties:

searchable_property_per_field.png

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

searchable_column.png

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>), QuickBase searches that field even if you've turned off the property for that field.

To exclude a single field from Quick Find and <Some field> searches:

  1. In the table bar on any application page, click the table whose fields you want to identify for searching. Within the menu that appears, select Customize -- tablename-- Table > Fields.

  2. Click the name of the field to open its properties.

  3. Click to clear the Include this field while searching/filtering this table checkbox.

  4. Click Save

To exclude several fields from Quick Find and <Some field> searches:

  1. In the table bar on any application page, click the table that contains the fields you want to identify for searching. Within the menu that appears, select Customize -- tablename-- Table > Fields. The field listing for the table appears.

  2. Clear the checkmark in the Searchable column for any field you do not want to include in search. If the Searchable column does not appear in the field list, click the Advanced Options link, select Searchable, and click Save.

Related Topics

 

This page refers to an older version of QuickBase. Online help is now located at http://www.quickbase.com/user-assistance/default.html.

 

Return to top   

© 1999-2013 Intuit Inc. All rights reserved. Legal Notices.