Table of Contents
- What are Tables?
- Manage Tables
- Table Settings
- Add Columns
Updated by Danielle Kellogg
- What are Tables?
- Manage Tables
- Table Settings
- Add Columns
What are Tables?
Tables are a type of view that displays multiple records from objects in your Live App. Each column in your table will correspond to a field in an object. Then each row in your table will correspond to an individual record in an object.
Tables can also contain action links that can view more details about a record, edit or delete individual records shown in the table, or trigger actions.
What Do Tables Look Like in the Live App?
In the Live App, a table displays as shown below. Fields from the object will be used as columns in the table, and records display as rows.
Adding, editing and deleting views are managed the same regardless of view type. To learn how to add, edit, and delete table views from your app, see About Views.
Where Do I Access Tables?
You can access your tables in the Pages section of the Builder. There you can either add a new table or select a page with an existing table view. There you can select and edit any table view in the page preview.
Once a table has been added, click directly on the table view in the page preview to open the view editor will open in the left side toolbox. Here you can access the view settings.
The table settings have the following sections:
- Source: control which records show in the table.
- Settings: control the pagination, filters, and options like adding exporting and inline editing.
- Column: choose which columns and links to display on your table.
The Source section displays which object the view is displaying and is used to control which records the table will display and how those records are displayed.
The following sections are available in the Source settings:
- Data: Add rules to define and limit which records will display.
- Sort: Define the sort order in which records will display.
- Limit: Define how many records to show. If you want to display only a certain number of records instead of all them, you can set a limit. For example, we may want to display our top 10 prospects, so we would set the limit to 10.
Click here for more on working with the view source.
The Settings section is where you will find the settings for your table to manage how elements of your table will behave. You can find more detail on table settings here.
The Options section contains four features that you can enable to customize your Table view:
- Keyword Search: This will add a search field above the table for the user to enter keywords that will filter which records to display. On the search results display, a “reset” link will appear. Clicking this will reset all search criteria to easily search again with new criteria.
- Exporting: This adds a link above the table allows the user to export all the data from the table into either a CSV, JSON or TXT format.
- Inline Editing: This allows the user to edit each field directly from the table, without utilizing a form view.
- Hide Empty Columns: Enabling this feature will hide all columns that are empty from the table view.
Empty Table Text
Here you can change the text which is shown when the table has no records to display.
By default this will show “No Data.” Add your own text here to add custom text for empty tables.
Column summaries are used to run calculations on all the rows in the column. Results will display as a summary at the bottom of the table columns.
Here you can add four different summary types to your table: Sum, Average, Minimum, and Maximum.
To add column summaries click the “Add Summary” button. Then add a title for your summary and select the summary type. By default the title is “Total” and any label you add will be placed in a left column if available.
When row summaries are enabled, you can disable it for specific columns if needed. To do so, hover over the column in the table preview and click the more options icon. Select "No" in the Allow Summary dropdown to hide the summary for that column.
Pagination determines how many records are displayed at one time on your table. If the total number of records exceeds the number set here, then a pagination control menu will be added to the table to navigate to additional pages, displaying more records.
- Set how many records to display at a time: tables can be set to show 10, 25, 50, or 100 records at a time.
- Let the user change the amount: once the page has loaded the user will be able to select how many records they will view per page. They can choose between 10, 25, 50, 100, 500 or 1000.
- Repeat pagination controls below the view: this will show the buttons to navigate to different table pages at the bottom of the table as well.
Here's an example of a table displaying pagination links in the top right:
Filter options allow you to customize how your user can filter the records in the Live App. Here you can disable filters for the user, allow users to add their own filters or add a predefined filter menu.
Don't allow records to be filtered
Selecting this option will prevent users from filtering the records in the table view on the Live App.
Allow users to add custom filters
Enabling this option allows users to add custom filters in your table when they access your app. Users will be able to select which field and criteria they want to filter by.
Here you can allow users to filter all fields and objects or limit which records and fields are available to filter by. There is the option to allow users to filter by all object fields or only the fields displayed within that view. Similarly here you can add internal filters to prevent all records from being returned by these filters.
This will display as an "add filters" link above the table:
The table will update as soon as a filter is added to the Live App and multiple filters can be added as needed. You can also set here if the available fields to filter are limited to the table columns or all of the object fields.
Use a filter menu
Enabling a filter menu will present links with predefined filters above the table. The user cannot change these filters. Clicking the will filter menu links will filter the records based on the rules you create.
The user can then click on the menu links to automatically filter the records.
Title & Description
In this section you can customize the table title and add a description. This is a great way to give your users more context about what the table is displaying
- Title: the text here will display as the main title above the table view.
- Description: here you can add additional description text that will display below the title
The Add Columns section defines which fields will show as columns on the table.
Here you can add or remove fields from the main object the table is showing, as well as fields from connected objects. These fields can be clicked or dragged onto the table view.
Read more on managing columns below.
Each individual field available to add to the table is associated with a field in your object or a connected object.
All the fields available to add as columns will be displayed in the view editor in the Fields, Connections or Actions sections.
The Fields section contains all fields from the primary object the view is displaying. Click on a field or drag it onto the table preview to add it as a column:
When the field is clicked it will be added to the right of the table as the last column by default.
In the Connections section you can add fields from connected objects. To add these fields click on a field or drag it onto the table preview to add it as a column:
In the Add Columns section you can manage Action Links, which allow you to add additional link columns to your table view. This is where you can add links to delete a record, edit a record, view more details about a record, link to another child page or trigger an action.
- Edit record: this will create a new child page with a form to edit the record. Clicking on the link will go to that page to edit the record.
- View record details: this will create a new child page that displays all further details for the record. Clicking on the link will go to that page to view those details. This is useful if an object has too many fields to fit in a table since you can pick a few to show in the table and then show more details on the linking page.
- Delete record: this will add a link to delete a record. When the user clicks on the link they will be asked to confirm the delete. Clicking yes will then remove the record from the table and delete it from the object.
- Link to another page: reuse another page you've already created by linking to it. For example, if you already have a complex page that shows details about a company record, we could link to that page instead of creating a new page for this table.
- Trigger an action: “Action Links” create a link on the view and trigger an action to (a) update this record / update connected records / insert connected records / send emails and (b) redirect to another URL or show success messages.
Learn more about using action links here.
To edit a field column, hover over a column in the page preview while editing the view and click the pen icon.
The toolbox will then display options to edit the column's properties, layout, and display rules.
Learn more about using column properties here.
Hover over a column and click the "trash can" icon to delete that column:
To move field columns on the table view, click the header of the column you would like to move and drag it to either the left or right.
Use Tables in your App
Tables and Connected Records
In addition to displaying fields from the object used to create the table view, you can also add field columns from connected objects as well. This will allow you to display records from multiple connected objects in one table.
Adding Columns from Connected Objects
When adding field columns, you can add columns from connected objects. In the Add Columns section of the table settings, fields from connected objects will be available in the “Connections” section. Here you can add columns to your table in the same way you would fields from the primary object.
Notes & Troubleshooting
- Adding a new field to your object will not automatically add this field to your table. You will need to manually add the field to your table columns for it to display.
- Deleting a table will also delete all child pages connected to the table if the child page doesn’t connect to any other views.
How To Guides
There are several How-To Guides that use table views to display records.
- Show records connected to the logged-in user.
- Show records connected to the logged-in user's company or other groups.
- Track customer orders in a table in an Orders App.
- Display inventory reports in an Inventory Manager or Warehouse Manager app.
- Keep track of edit logs with a Version Control History for Records.