When you create a Table report, you can choose which information to display in what format.
To create a table report:
Select a table from the Table bar.
Click REPORTS & CHARTS to open the reports panel, then click +New.
Select Table and then click Create.
Add a name and description.
In the Reports & Charts panel section, choose which users can view the report, or make it a personal report.
Specify which columns to display in the report. You can use the defaults for this table, or choose Custom columns to select from a list of all available columns, plus choose the order you want either by clicking and dragging column names, or by using the ordering arrows.
To add a calculated column:
Select Define a calculated column.
Add a column label.
Select a field type, and enter a Formula.
More about columns
In the Filters section, you can customize the data that displays. You can set initial filters to include only relevant data and also define dynamic filters that enable users to change the report display. More about filters.
In the Sorting & Grouping section, set the report sort order and grouping of data using one or more fields.
In the Options section, you can set one or more display and formatting options:
Hide totals & average: Hides all totals and averages rows on the main table
Record Actions: Choose to allow editing records from this report, allow viewing records from this report, or display only new or changed records
Normal (default) displays in your browser
Comma-separated values (.csv)
In the Color-Coding section, you can select to add color to report rows based on a formula. More about color-coding.
Click Save at the top of the page.
© 1999-2018 QuickBase, Inc. All rights reserved. Legal Notices.