Table of Contents

How to Add Groupings to a Table

Sarto Jama Updated by Sarto Jama

Scenario

Tables are an excellent way to display information in your Knack apps. Especially since they offer many features to further organize your data for easy understanding.

For example, let's say you want to create a table that quickly shows which donors are making the most donations. So you start with a table that shows all donations:

It's not a bad start, but it's not easy to tell who your best donors are. That's where a feature like grouping can make all the difference.

Grouping allows you to group records by a common value in selected table columns. Here’s what your table will look like when it's grouping the donations by donor:

With a header row for each donor and their donations listed below them, you can see who’s in the giving spirit, at a glance.

Plus, since the "Amount" column was already totaled using a row summary, the grouping now shows the total per donor. Though there’s still a complete total for all donors at the bottom of the table:

Requirements

If this your first time creating an app, you'll need to know some basics about adding objects, fields, pages, and views. You can start by watching our "Introducing Knack" video tour and then working through the articles in our Builder Basics section. Other good resources can be found in our designing the database and building pages sections of the knowledge base.

Steps

Here's a quick video walkthrough of the steps below:

  1. Select the Page with the Table

In the Pages section of the builder, select the page that holds the table you want to add grouping to.

  1. Open the Table Editor

Click on the table in the Builder or click on the pencil-icon for the table on that page to open the editor.

  1. Edit the Field/Column

Hover over the column you want to add grouping to and click the edit “pencil” icon to edit that column.

  1. Enable Grouping

Enable the grouping option by checking the “Grouping” box:

Once grouped, the field will form a column across the table:

Notes & Troubleshooting

  • Groupings on views do not currently export. 

How did we do?

How to Add a Map to a Details View

Contact