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:
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.
Here's a quick video walkthrough of the steps below:
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.
Open the Table Editor
Click on the table on that page to open the editor.
Edit the Field/Column
Hover over the column you want to add grouping to and click the edit “pencil” icon to edit that column.
Enable the grouping option by checking the “Grouping” box:
Note: Any columns that are grouping records will automatically move to the front of the table. A small "group" icon will appear in that column to indicate it is grouping: