The Options section provides additional settings for your table.
Pagination determines how many records will show at one time. If the total number of records exceeds the number set here, then links will be added to the table to navigate to additional pages, displaying more records.
Here's an example of a table displaying pagination links in the top right:
You can set how many table rows to show at a time, as well as allowing the user to change this number if desired.
The Options section contains four features that you can enable to customize your Table view:
- Enable users to export table records
- Make changes using inline editing
- Hide empty columns from view
- Set the text that will display when there is no data in the table
You can read more about working with tables here.
Displaying a keyword search will present a search field above the table for the user to enter keywords to filter which records will display. These keywords will search the entire record.
Note: The keyword search will be combined with any rules added to the Data Source section.
Exporting allows the user to export all the data from the table into another format. An "export" link will appear in the top left, with options for downloading in a CSV, Text, or JSON format:
Knack Tip The exported data will always reflect the exact data the table is displaying, including any sorting and filters.
Inline editing allows the user to edit each field directly in the table, without using a form view. When enabled, the user simply has to click on a table cell, and a form pops over it to edit that cell:
Inline editing can also be disabled for specific fields. When editing a column, select "No" in the Allow Inline Editing dropdown to disable inline editing for that column:
Knack Tip Once inline editing has been enabled, it will affect all columns. You will need to manually disable it for each column.
Hide Empty Columns
Enabling the "Hide empty columns" option will hide any columns on the table that are empty.
"No Data" Text
Here you can change the text which is shown when the table has no records to show. This will replace the default "No Data" text.
Row summaries are used to run calculations on all the rows in the column. Results will display as a summary at the bottom:
You can also add Formula options, such as Sum, Average, Minimum, and Maximum, to your table.
Any label you add will be placed in a left column if available. You can use the green "add" buttons to add multiple summaries:
When row summaries are enabled, you can edit each table column to disable it for a specific column, if needed. To do so, hover over the column and click the pencil edit icon. Select "No" in the Allow Summary dropdown to hide the summary for that column.