Filtering and Sorting the Field List

Some QuickBase users have tables with hundreds of fields. In these cases, filtering the field list shown on the Fields tab to show a subset of those is often useful.

Filtering by Searching the Field List

The Search box appears at the top of the Fields tab. Type a search term to limit the fields shown to ones whose names contain that term. The Search box will search in the Field Label column only.

Filtering by Showing Categories of Fields

The Show dropdown list contains a list of field types that can be used to filter the fields displayed for the current table. Choose one of the following options:

• All Fields – Show all fields. Use this to remove any filtering currently in place.

• Text – Show fields with Text types (including Text, Text - Multi-line, and Text - Multiple choice).

• Numeric – Show fields with Numeric types (including Numeric, Currency, Percent, and Rating).

• Date – Show fields with Date types (including Date, Date/Time, Time of Day, and Work Date).

• Duration – Show fields with type Duration.

• Checkbox – Show fields with type Checkbox.

• Phone Number – Show fields with type Phone Number.

• Email Address – Show fields with type Email Address.

• User – Show fields with type User.

• List - User – Show fields with type List - User.

• File Attachment – Show fields with type File Attachment.

• URL – Show fields with type URL.

• Report Link – Show fields with type Report Link.

• iCalendar – Show fields with type iCalendar.

• vCard – Show fields with type vCard.

• Record ID# – Show fields with type Record ID#.

• Relationship – Show fields that are part of relationships (Summary, Report Link, Formula - URL, reference, lookup, and proxy fields).

• Formula – Show fields that are formulas.

• Default in reports – Show fields that will be automatically added to QuickBase reports.

• Reportable – Show fields that will be used in lists of filtering criteria in QuickBase.

• Searchable – Show fields that will be searched for in Quick Find and <Some field> searches in QuickBase.

Note that the field properties in the Show dropdown will be greyed out and unselectable if no fields with those properties are in the current table.

Sorting the Field List

By default, the order of the fields in the field list is the order QuickBase uses when it displays default columns in a report, and when you export data from a table. You can change the order of fields in the field list by dragging and dropping. If you have selected one or more fields using the checkbox to the left of the field name, you can drag and drop them to reorder the fields. Alternatively, you can drag and drop one field without explicitly selecting it. The cursor indicates that the drag & drop functionality is available:

While dragging, a horizontal line indicates the place where the field(s) will be dropped, and the tooltip gives exact information about the number of fields being dragged and the drop location. Any reports created after this operation will contain the fields in the new order.

If you prefer to sort fields by a column in the field list, click the Advanced Options link, select Enable column sorting, and click Save. Click a column heading to sort by that column.

Field drag and drop is disabled while you have fields sorted by a column, and a warning to that effect is displayed at the top of the screen. Click the Return to field list order link to re-enable drag and drop.

Note: Sorting fields by a column in the field list does not affect the order of default columns in reports you create or data you export.