Data tables automatically collect data from Forms for reporting and other uses. By default, a new Form definition lacks a data table configuration, as shown by the “Has Data Table” column in the Form definitions table.  

Choose the Form Definition, then click the "Actions > Data Table" menu option.  

Enter the target table name in the input box provided, then click the "Add" button.

The data table features an alert notification. The column displays all the Form fields alphabetically.   

The Form Definitions page verifies the connection of the data table, as illustrated below.  

Use the Search feature to locate a Form field by name. 

Click the “Update” button to refresh the data table when you add or remove fields in the Form Definition. Note: The “Update” feature keeps Form changes synchronised with the data table by removing unnecessary columns. 

When the Form is submitted at runtime, the data table is populated with values from the Form fields. To manage data tables for all Forms, go to the Create > Data Table page. The “# of Records” column shows the total number of records. 

Select the data table on this page to see its contents, as shown in the images below.

Choose the record to see more details.

Actions - View Data Table Data.

Use this feature to view the data table.  

The data appears on the new page as shown in the example below. 

Actions - Remove Unused Columns.

Use this feature to remove unused columns. These columns are not utilised when the data table schema is modified by deleting controls in the Form Definition, even if data already exists. 

A notification message appears in the top-right corner. 

Actions - Delete Table.

Use this option to delete data from the table.

An alert appears. Click OK to permanently delete the data. 

Control-ID changes to a Form having a Form Data Table:

When you change the Form’s “ControlID or Name,” you see an alert notification, as shown in the example below. This happens when the Form is linked to a data table that contains existing data. Note: Select “Ok” to change the “ControlID or Name” if needed. Doing so will result in data loss in that column of the data table.