How to have address field labels in different columns in submisisons page?

  • Profile Image
    Asked on March 03, 2018 at 09:58 AM

    When reviewing submissions the spreadsheet view has column headings but then also prefixes the results again with field labels. How do we change this so that only the data (answer given on forms) is displayed. When exporting to Excel or CSV we have to clean all those labels out which is time consuming and very inefficient.

  • Profile Image
    Answered on March 03, 2018 at 02:05 PM

    Unfortunately this is not possible since the Prefixes are considered to be one field and can not be separated. However if you need to have the different Prefixes in  their respective columns, you will need to create independent field for each prefix you need to create its column.

    This means instead of using address field you will create separate text Fields for Street, City and State fields.

    These fields being separate means in the submissions page each of this field will be in its separate column.