Tables

📘

Not sure how to configure a form? Learn more...

Dynamic tables

Dynamic tables have an external data source (in CSV or JSON) and can change as the source changes.

Top create a dynamic table:

1. Select the Table form field.
2. Click to configure the table the table and select Dynamically create table from external data source. You can either use data reference to link to the source and make the content dynamic or enter the table content manually. If you enter the data manually, make sure it's in the following format:

[["Company", "Order", "Shop nr"], /*if header is selected, these are the header values*/
 ["5", "1104", "400"], /*these are the values in one row; each value gets a separate column*/
 ["6", "1104", "400"], 
 ["7", "1104", "400", ""]/*if there is no value, leave the double quotes empty*/
]

Tip: If the data is pulled from an external source, make sure the source contains the data. If there is no data to fill the table, it will show as empty and the users won't be able to add rows to it, even if you select Allow users to add and remove rows.

See how to edit table values

1. Click the value in the table.
2. Update the value and hit Enter.

Predefined tables with validation

You can predefine tables for users or add input validation based on the content type you select for each column.

1. Select the Table form field.
2. When you configure the table the table, select Predefine table.
3. In the Headers section add the names of header columns and (optionally) select the type of input for each column. For example, if you choose Text as the Allowed content type, users won't be able to add any numbers when editing the column in a running workflow instance.

📘

If you add a file as an external source of data for the table and the data in the file won't match the selected Allowed content type, this data will be ignored and will not show in the table. Additionally, make sure sure the number of columns you name corresponds with the number of columns in the source. If there are extra columns in the source, they will be ignored.

3. (Optional) Select or enter the data source. If you want the table to be empty, leave the field blank. However, make sure to select Users can add and remove rows in the Table layout and content so that users can add rows to the empty table.
   If you want to enter the content manually, follow the structure below. Note that you define headers separately in the Column headers and validation section.

[
 ["5", "1104", "400"], /*these are the values in one row; each value gets a separate column*/
 ["6", "1104", "400"], 
 ["7", "1104", "400", ""]/*if there is no value, leave the double quotes empty*/
]

Read-only tables

You can make dynamic and predefined tables read-only by enabling the Make table read-only toggle. This option is useful in steps when users need to review or approve table data without editing it.

Note that when tables are read-only, users can't add rows or edit table cells so make sure the table that displays already contains data and is not empty.

Add tooltip to field

You can add extra information to help users provide the right input. The information will show when users hover over the info icon next to the field name.

Complete a form using API

You can update field data and complete a form using API. To see examples of the JSON body you need for each form field, see Completing steps.