Sometimes you want different people to have a different view of a table. You might want users in one role to see a specific report (maybe a summary report or a report showing the high priority records), while the rest of your users get a listing of all records in the table. Or you might simply want to always show an advanced search form so that people can search for the exact records they want. If you have admin access to the table, you can do this.
Open the table Home page settings. You can do this in one of the following ways:
If you have clicked the table to display the table Home page, click the Customize this Page link on the Page bar.
In the Table bar, click a table. Click SETTINGS on the Page bar, then click Table home page in the User Interface section.
Select one of the following options:
The same view for everyone. If you choose this option, select the view from the dropdown: Default report, Advanced Search form, or choose a report to show on the table Home page. If you choose the default report or a specific report, the table Home page may show dynamic filters, depending on how the report was configured.
A view based on the user's role. If you choose this option, a row for each role in the app appears. Using the dropdown in a role’s row, select the view for that role. If you don’t set the view for a role or the view you choose is not allowed for that role, QuickBase uses the view you specified for Everyone.
Grid Edit reports cannot be shown on the table Home page, and will not appear in the dropdown.
For performance reasons, if the report shown on the table home page contains more than 10,000 records, the Advanced Search form is shown instead.
If you choose to display the default report on the table Home page, the columns shown will be based on the default report settings for the specified table. Use one of the methods below to display the default report settings page:
When you're looking at the Table home page settings, click the Default report settings link in the table.
When you're looking at the Reports & charts settings page, choose Reporting defaults > Default report settings from the menu in the Page bar.
When viewing a report, click More > Set default columns.
The default report settings include: the default columns, the order of default columns, settings for the dynamic filters that can appear to the left of a report, and the field that the default report is sorted on. Read more.
Remember that these settings affect other areas of QuickBase.
The data shown by the default report isn't a report that's accessible from the reports panel. You can filter the data there and save it as a report, but that action does not change the default report.
If the table Home page has been configured to show a report or the default report, and dynamic filters are turned on for that report, then the list of dynamic filters is displayed on the left side of the table Home page.
Note: If a report shown on the table Home page has no records, the filters are not shown. Read more.
The table below shows the field types that can be dynamic filters. Field types not mentioned in this table (including Formula fields) cannot be dynamic filters.
|Field Type||Field||Reference Field||Reference Proxy or Lookup Field|
|Text - Multiple-choice||Y||Y|
*Note: Address fields and all of their subfields are text fields and as such can be used as dynamic filters.
The most common reason for filters being disabled has to do with the number of values for a field, and the length of those field values.
If a field has a value longer than 512 characters, dynamic filters for that field will be disabled.
If a field has over 200 values, it will display with a message that there are too many values to use for filtering. If all the filterable fields have too many values to display, you are directed to a search page so you can search for and display a subset of your data.
If a field has 60-200 values, some values will display, and the last item in the list will be an All Choices link, which opens a dialog with all the choices available for that field.
To refresh the filter list, click the table name in the Table bar. The filters and values in the filter list are not updated as you modify your data, for example, if you add a new choice to a multiple-choice field. Reloading the page using the browser controls will also not update the filter list.
Return to top
© 1999-2014 Intuit Inc. All rights reserved. Legal Notices.