Creating tables

Edit online

In the Form Response Builder, you can create dynamic and static tables. Dynamic tables allow users to add and remove rows as needed. Static tables are like dynamic tables, but with pre-defined values in the first column.

About this task

When you add columns, you must enter the table’s code in the Parent Code column. The parent code helps ensure that the system correctly links the columns to the intended table.

Procedure

  1. In the Parent Code column, enter the table’s code.
  2. In the Code column, specify a unique ID.
    Option Steps
    Create a dynamic table
    1. In the Entity column, specify Table.
    2. In the Type column, specify Dynamic Table.
    3. In the next row, in the Entity column, specify Column.
    4. Specify the type of column that you want in the Type field.
    5. Set a display order for each column. The display order determines the sequence in which your columns appear. As with regular fields, you can also set properties for your columns, such as minimum and maximum.
    6. In the Value column, for each row, write short text that serves as column headers.
    Figure 1. Example of dynamic table in the Form Response Builder worksheet
    Illustration showing dynamic tables.
    Figure 2. Example of dynamic table output
    Image of a dynamic table that has this sentence at the top: Please list all climate-related programs or intiiatives your organization is currently implementing.
    Create a static table
    1. In the Code column, specify a unique ID.
    2. In the Entity column, specify Table.
    3. In the next row, in the Entity column, specify Column.
    4. In the Type column, specify Static Table.
    5. In the next row, in Type column, specify Text – Read Only.
    6. In the next row, in Type column, include the pre-defined values as rows for the first column by specifying Response and then DefaultResponse.
    7. In Value column, write the pre-defined text that you want to see as rows in the first column of your static table.
    Figure 3. Example of static table in the Form Response Builder worksheet
    Illustration showing a static table configuration.
    Figure 4. Example of static table output
    Image of a static table that has this sentence at the top: Please provide details of your organization's climate targets by scope.