Table reports

Prev Next

Use table reports

Table reports, which have been optionally available since Summer 2020, are becoming the default table report style during Spring 2021.

If new style table reports are your default setting, you can switch individual reports back and forth between the legacy and new style using the New style switch near the top right of the report.

The New style toggle switch in the top right of a table report

We encourage you to transition to the new style, since we eventually plan to retire the toggle and the legacy table report style.

The new table report is designed to feel familiar to existing Quickbase users, but offers simpler workflows and a cleaner look, and opens the way for future improvements. Most tasks are identical to what you're used to in the legacy table report. This article describes the navigation styles and workflows that have changed slightly.

Benefits and changes to the new table report style include:

  • Better look and feel with full-screen mode and resizable columns

  • Pale and full color-coding options

  • Nested record grouping

  • Pages with improved navigation

  • More prominent download button

A table report displayed in full-screen mode

Create a table report

Create a table report the same way you always have. Learn more about creating table reports. When you're done, you'll see it in the new style by default. You can switch the style back and forth using the switch.

  1. Select Reports & Charts to expand the Reports and Charts panel.

  2. Select + New. The New report or chart dialog opens.

  3. Select Table and select Create. The Create a New Report page opens.

  4. Select from the configuration options. When you're done, select Display to see a preview or Save to finish.

Adjust the display of your table report

The new table report style offers flexible display options that help you maximize space.

Open your report to full screen mode by selecting the full screen icon Full-screen icon.

Animation showing a table report being opened in full-screen mode

Adjust column widths for yourself by hovering over any column border and then click and drag to resize columns in any report. Quickbase remembers column sizes for each user. This means that when you resize a column, your adjustment persists when you close and reopen Quickbase, but has no effect on any other user of the new table report.

All columns have a default size based on their title and content. No one, including builders, can set column widths for any other report user.

Animation showing a column being resized by dragging its border

For additional spacing options, open theThree-dot menu icon menu and choose from relaxed, normal, or condensed spacing.

The spacing options menu showing relaxed, normal, and condensed options

If you use this menu to select a spacing option that is different from your Quickbase UI Spacing default setting, your selection will always appear in that specific report, but won't apply to any other reports.

The default appearance of color-coding in new table report style is pale, but you can switch it to a more noticeable full-color version.

A table report with pale color-coding applied to rows

Pale colors

A table report with full color-coding applied to rows

Full colors

To switch the default appearance for new style reports and reports that don't have individual settings, open the report builder, select Edit this default in the Color-Coding section, and select your preferred setting.

The Color-Coding section in the report builder showing the Edit this default option

Switch between pages in the new table report style by selecting the arrows and numbers at the bottom of the page with your mouse or keyboard.

You can also type a page's number to go directly to that page, or move one page at a time by selecting the page number box and pressing Shift + arrow key.

The page number navigation bar at the bottom of a table report

Download a new table report's records

Download all the records in a report as a CSV file by selecting the Download report as a CSV Download report as CSV iconicon.

The Download report as CSV button in the table report toolbar

The new table report style downloads as a CSV and includes all the records your table report contained in Quickbase, with all the fields shown in the report.

Show columns

Select Show columns from the column menu to display additional columns on a report. This feature was called Add a column in the legacy report style, and is located in the same place.

The Show columns menu in a table report column header

Select the right corner of the column header to find Show columns. When you select Show columns, a window appears where you can search for fields or select them from a menu. When you're done, select Apply.

If your permissions let you customize the report, access the column menu by selecting the right side of any column header.

Use dynamic and column filters

In the legacy table report style, builders select dynamic filters to appear on the left of the page. Dynamic filters are always visible at the top of your report. To apply a filter, select it and choose from its list, type into its text box, or use its date pop-up.

Dynamic filters displayed at the top of a table report

The process for builders to add dynamic filters to a report hasn't changed.

All columns that are used as dynamic filters load when you open the report. Get filter information for all other columns by selecting the funnel icon Column filter iconnext to the search bar and selecting the column header. Then, the filter information loads.

The funnel icon next to the search bar for accessing column filters

Filter and sort columns by selecting the funnel icon Column filter iconand then selecting the column header. Sort columns by selecting the column header.

When a filter has a text box, you can enter a partial term like Carolina. You can also use AND and OR, like Carolina AND south or Carolina OR Dakota. When a filter has a choice list, you can search and select exact terms, like North Carolina.

Column filter options

Column filtering isn't available for these types of columns in the new table report style:

  • Report Formula

  • Report Link

  • Duration / Formula - Duration

  • File Attachment

  • iCal (in retirement)

  • vCard (in retirement)

Group rows

Builders group rows in the same way, but now, if you group your report on multiple fields, each group is nested within the group above it. You can collapse and expand groups based on what information you need to see, making reports more scannable. This change maximizes space and creates a clearer hierarchy in reports.

Animation showing nested row grouping in a table report