Creating different fields

Edit online

In the Form Response Builder, you can create different types of fields, such as Text, Year, Date, Number, Whole Number, Integer, and Boolean fields.

About this task

When you add columns, you must enter the table’s code in the Parent Code column. The parent code tells the system which field the property belongs to and helps ensure that it is applied correctly

Procedure

  1. Specify a parent code.
  2. In the Code column, specify a unique ID.
  3. In the Entity column, specify Field.
    Option Steps
    Create a text field
    1. In the Type column, specify either Short Text or Long Text depending on the level of detail you expect in the field.
    2. In the next two rows, in the Entity column, specify Properties and in the Type column, specify MinLength and MaxLength.
    3. Set a display order for each column. The display order determines the sequence in which your columns appear.
    4. In the Value column, for each row, write short text that serves as field titles.
    Figure 1. Example of short and long text fields in the Form Response Builder worksheet
    Example of short and long text fields that have minimum and maximum field lengths specified in the Form Response Builder worksheet
    Figure 2. Long text example output
    Example of a long text field that has the text Please describe your organization's overall climate change strategy and how it aligns with your sustainability goals.
    Figure 3. Short text example output output
    Example of a short text field that has the text Please disclose the Job Title of the ESG Responsible Person in your organization.
    Create a year field
    1. In the Type column, specify Date.
    2. Set a display order. The display order determines the sequence in which your columns appear.
    3. In the Value column, write short text that serves as the field title.
    Figure 4. Example of a Year field in the Form Response Builder worksheet
    Example of a year field that has the value What is the baseline year for your primary climate target?
    Create a date field
    1. In the Type column, specify Date.
    2. In the next two rows, in the Entity column, specify Properties and in the Type column, specify Minimum and Maximum.
    3. Set a display order for each column. The display order determines the sequence in which your columns appear.
    4. In the Value column, for each row, write short text that serves as the field titles.
    Figure 5. Example of a date field in the Form Response Builder worksheet
    Example of a date field that has the value When was your climate target officially approved or published?
    Figure 6. Example of a Date field output that has the format YYYY/MM/DD
    Example of a date field output that has the format
    Create a number field
    1. In the Type column, specify Number.
    2. In the next three rows, in the Entity column, specify Properties and in the Type column, specify Minimum, Maximum, and MultipleOf.
    3. Set a display order for each column. The display order determines the sequence in which your columns appear.
    4. In the Value column, for each row, write short text that serves as the field titles
    Figure 7. Example of Number field in the Form Response Builder worksheet
    Example of Number field in the Form Response Builder worksheet
    Figure 8. Example of Number field output
    Example of a number field output that has the label What is your absolute emissions reduction target? and is populated with the value 30.4
    Create an integer field
    1. In the Type column, specify Integer.
    2. In the next rows, in the Entity column, specify Properties and in the Type column, specify MultipleOf.
    3. Set a display order for each column. The display order determines the sequence in which your columns appear.
    4. In the Value column, for each row, write short text that serves as the field titles
    Figure 9. Example of Integer field in the Form Response Builder worksheet
    Figure 10. Example of Integer output
    Example of a number field output that has the label How many climate-related programs or initiatives are currently active in your organization? and is populated with the value 7
    Create a whole number field
    1. In the Type column, specify Whole Number.
    2. In the next three rows, in the Entity column, specify Properties and in the Type column, specify Minimum and MultipleOf.
    3. Set a display order for each column. The display order determines the sequence in which your columns appear.
    4. In the Value column, for each row, write short text that serves as the field titles
    Figure 11. Example of Whole number field in the Form Response Builder worksheet
    Example of a Whole number field in the Form Response Builder worksheet
    Figure 12. Example of Whole number field output
    Example of Integer field output that has the Value How many years are remaining until your target year? and the value 5.2
    Create a Boolean field
    1. In the Type column, specify Boolean.
    2. In the next rows, in the Entity column, specify Definitions and in the Type column, specify Option.
    3. Set a display order for the first row.
    4. In the Value column, for the first row, write short text that serves as the field title.
    5. In the Value column, for the definition rows, enter Yes and No values.
    Figure 13. Example of Boolean field in the Form Response Builder worksheet
    Example of a Boolean field in the Form Response Builder worksheet
    Figure 14. Example of Boolean field output
    Example of a Boolean field output that has the question Has your organization set a formal climate change target? and the radio buttons Yes and No.