Can the label names be different from the underlying field names?

  • Profile Image
    youngivyacademy
    Asked on July 31, 2019 at 07:23 PM

    There is a label (or a field name) next to a field which is supposed to be filled out. When we download it as a CSV file, these labels are supposed to become column headers. Can the label names be different from the underlying field names (which would have become columns in CSV)? I hope that I make my questions clear.

    You guys are great. Appreciated.



    This is a re-post of a comment on How to Download Form Submissions as Excel/CSV/PDF

  • Profile Image
    gerardw
    Answered on July 31, 2019 at 08:10 PM

    When you download the submission as a CSV file, it captures the sub-labels into the column headers. Please check an example below:

    15646179940108_2.png

    When we download a CSV file, the sub-labels become the column headers:

    15646180360108_3.png

    This is how the downloads in Excel and CSV currently looks. So could you explain which labels are you referring to?

    For example: If you want "Name" field, from the above screenshot, to show as the column header in the CSV file, then you will need to manually add it after downloading the CSV.

    If not, please provide us additional information.

  • Profile Image
    youngivyacademy
    Answered on July 31, 2019 at 09:33 PM

    I know what you mean. How about those without sub-labels (in  my case) such as 

    1st Parent's Cell Phone *

    1st Parent's Email

    Birthdate

    start date

    Schools

    Thanks!

  • Profile Image
    roneet
    Answered on July 31, 2019 at 11:25 PM

    Unfortunately, you cannot have separate names in the Form fields and in the column of the downloaded Excel. 

    As a workaround you can follow any of these:

    Method 1: After you download the excel submission, manually edit the columns


    Method 2: Manually change the form field name to the value you want in the Excel sheet 

    Let us know if you have further questions.

    Thanks.

  • Profile Image
    youngivyacademy
    Answered on August 01, 2019 at 10:05 AM

    With the following labels, will they become column headers since there are no sub-labels under them?

    1st Parent's Cell Phone *

    1st Parent's Email

    Birthdate

    start date

    Schools

  • Profile Image
    Richie_P
    Answered on August 01, 2019 at 11:36 AM

    Yes, the following fields will the be the column header. However we can't control how the column headers are created when downloading the submission as Excel.