About Dynamic Filters

Dynamic filters are a set of fields and values that can be configured to appear on the left side of a report. These filters allow you to quickly narrow down the data displayed to only those records you care about. If the report is shown on a table Home page, the dynamic filters appear there as well.

Using dynamic filters

The filterable values for a field appear indented beneath the field name. If a field has many values and you're not interested in filtering on it, you can collapse it by clicking the arrow to the left of the field name. (The Company and Priority fields are collapsed in this manner in the image above.)

Setting dynamic filters for pre-existing reports

The ability to set whether dynamic filters are visible for reports was released in May 2013. For users with reports created before then, QuickBase includes a one-time way to turn on dynamic filters for those existing reports.

To turn on dynamic filters for all common reports:

  1. Click a table on the Table bar.

  2. Click Settings on the Page bar.

  3. Click Reports & charts.

  4. There is a message box above the list of reports. Click the Turn on filters for all common reports button to turn on dynamic filters for all reports in your app, not just the current table's reports.

This message also appears on the Manage Reports page (accessible from App management on the app settings page).

To turn on dynamic filters for all personal reports:

  1. Click the user dropdown on the Global bar.

  2. Choose My personal settings in <app>.

  3. Click My reports & charts on the left side of the page.

  4. There is a message box above the list of reports. Click the Turn on filters for all personal reports button to turn on dynamic filters for all personal reports in your app.

Setting dynamic filters for a single report

You can set the dynamic filters that appear on a report using the Report Builder. Dynamic filter settings on a report override any default settings that may exist.

To specify a set of dynamic filters for a report:

  1. Open the report in the Report Builder.

  2. In the Filters section, see Dynamic filters. These controls let you indicate whether to show dynamic filters, and which fields will be shown for filtering. You can choose to hide dynamic filters (None), use the default dynamic filters (Use the dynamic filters defined in default report settings, or specify which fields to show (Custom).

    Note: If you choose to hide dynamic filters, you can also choose to hide the Search box that appears at the top of the report. To do so, choose None, then select the Allow users to search using the Quick Search field checkbox.

  3. If you chose Custom, you can specify up to five dynamic filters. The fields shown in the list box on the left are the fields that can be used as dynamic filters. The current set of dynamic filters is shown in the list box on the right. Drag fields out of the list box on the right to remove them; drag fields into the list box to add them to the set of dynamic filters for the report. (You can also use the Add and Remove arrow buttons to move fields back and forth.)

  4. If you'd like to change the order of the dynamic filters, drag them up or down in the list box, or use the Up and Down arrow buttons.

  5. When you're finished, click Save on the Page bar to save the report with your changes.

Specifying a default set of dynamic filters

If you're tired of setting dynamic filters for each report in your app, there's a way to specify a default set of dynamic filters by editing the default report settings for the table. These defaults take effect if the individual report's dynamic filters are set to Use the dynamic filters defined in default report settings.

To specify a default set of dynamic filters:

  1. Click a table on the Table bar.

  2. Click Settings on the Page bar.

  3. Click Reports & charts.

  4. Click Reporting defaults > Default report settings on the Page bar.

    The Default dynamic filters section lets you indicate what filters to show by default. You can choose to hide all dynamic filters (None), use the defaults implied by the selection and order of default columns (Set automatically, or specify which fields to show (Custom).

  5. If you choose Custom, you can specify up to five default dynamic filters. The fields shown in the list box on the left are the fields that can be used as dynamic filters. The current set of default dynamic filters is shown in the list box on the right. Drag fields out of the Default dynamic filters list box to remove them; drag fields into the list box to add them as default dynamic filters. (You can also use the Add and Remove arrow buttons to move fields back and forth.)

  6. If you'd like to change the order of the default dynamic filters, drag them up or down in the list box, or use the Up and Down arrow buttons.

  7. When you're finished, click Save on the Page bar to save your changes.

QuickBase field types used for dynamic filters

The table below shows the field types that can appear as dynamic filters. Field types not mentioned in this table (including Formula fields) cannot be dynamic filters.

Field TypeFieldReference FieldReference Proxy or Lookup Field
CheckboxY Y
DateYYY
Date/TimeYYY
PredecessorY
Text*YYY
Text - Multiple-choiceY Y
UserYYY
Work DateYYY

*Note: Address fields and all of their subfields are text fields and as such can be used as dynamic filters.

Why aren't my filters appearing?

Occasionally, none of the dynamic filters you've configured for a report appear when you view the report. How does QuickBase decide which filters to display?

If you're using the Use the dynamic filters defined in default report settings option for dynamic filters on that report, look at the first ten fields in your report. Do the fields used in default dynamic filters appear within the first ten fields in your report? If not, change the order of report columns so that your filter fields appear within the first ten columns of the report.

Other factors that will affect whether or not dynamic filters will appear:

 

Related Topics:

 

Return to top   

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