Table fields provide an inline tabular display of repeating data, and the ability to add & edit rows through a dedicated row page. Users can add rows through the 'Add New Row' button, and can edit existing rows by tapping on the displayed table row.
The columns of your table are defined by the form fields that you place within the table through the form designer. By default, the table will display columns for each inner field based on the order the fields appear within the table field design.
The background colour, font size and many other aspects of these inner fields are incorporated to the column display of the table. Users can choose to exclude fields from being displayed as columns via the 'Disable Column Display' property found on all inner table fields. Users can also choose which fields should act as columns in the table's display.
The app automatically restricts the maximum number of columns displayed based on the size of the device. On phones, tables are limited to displaying a maximum of 3 columns. On tablets, the app will allow up to 6 columns.
Tables also provide further configuration options. For example, users can customize the default 'Add New Row' button as desired. This button appears at the bottom of the table display on the app. It allows users to add rows to the table. When the button is tapped by the user, the app will navigate to a special row page that displays the fields they've dragged into the table design. After filling in one row the user can navigate back to the main form page, or navigate forward to add another row to the table.
Using formula functions with tables
The table field can be thought of as a repeatable page. This means that repeat-specific formula functions can be used with table fields. For example, users can copy forward values from the previous table rows via the PRIOR('fieldname') function. Users can also use SUM('field') and other such functions in fields outside the table to perform aggregate calculations on table fields.
Table fields can be pre-populated via our Task API and inbound field parameters. These are passed via an 'Open Screen' interaction launched from a prior screen. Tables cannot be auto-populated from a data source, but we're working on it for a future release.
Current table limitations
Tables have some restrictions that should be noted when considering your form design:
- Tables placed within repeatable pages are not supported, particularly for data template outputs.
- Image/media fields do not currently display as columns.
- Dedicated totalling is not available on tables, we're working on it for a future release.
- Tables cannot be auto-populated from a data source, we're working on it for a future release.