Connect form controls to table columns

Form controls can be connected to columns in the table that the form is associated with. When you connect a control to a table column, data entered in the control is stored in that column when a form is submitted.

You can connect a control to an existing table column or create a new table column directly from the Form designer and connect the control to it.

Use the Connected to configuration field to connect the control to a table column.

Note: The Connected to setting is available only for controls used in table forms.

Use the Connected to configuration field in table forms to:

  • Connect a form control to an existing table column.

  • Create a new table column directly from the Form designer and connect the form control to the new column.

  • Capture and save user input to the corresponding table column.

For more information form controls, see Form controls.

Jump to:

Connect a form control to an existing table column

  1. Open the table form you want. For instructions, see Open a Table form.

  2. Select the form control you want to connect to a table column.

  3. In the Connected to field of the form configuration panel, select the table column you want to connect the control to.

    Only table columns that are compatible with the selected control are available.

  1. Configure the remaining properties for the control as required.

  2. Save the form.

The control is now connected to the selected table column. When a user submits the form, the value entered in the control is saved to the connected table column.

Create a new table column from the Form designer

You can create a new table column directly from a table Form designer and automatically connect a form control to the new column.

You can:

  • Create multiple table columns: Create multiple table columns at once from eligible form controls using the Create table columns toolbar option.

  • Create a single table column: Create a single table column from the form configuration panel using the Connected to field and connect it to the selected form control.

Create a new table column

  1. Open the table form you want. For instructions, see Open a Table form.

  2. Add the required form controls to the form.

  3. Create the table column using one of the following methods:

    • Create multiple table columns: On the toolbar, click Create table columns.

      Note: 

      • The Create table columns toolbar option is enabled only when the form contains form controls that are not connected to a table column.

      • Label, Image, Group, and Space form controls are not supported for automatic table column creation.

      • Use this option when you want to create multiple table columns at once instead of creating them individually.

    • Create a single table column: Open the form configuration panel and in the Connected to field, open the drop-down and select Create table column.

    The Create table column dialog is displayed.

  1. (Optional) In the Table column name, enter a name for the new column.

  2. Click Create.

The table columns are created and the corresponding form controls are automatically connected to the new columns.