Is there a way to make the column titles for the downloaded form entry spreadsheets shorter?

  • Dave
    Asked on August 11, 2019 at 4:49 PM

    Hi I am using your GSheets integration tool to auto-populate online form submissions into a Gsheet (which is super-cool, thanks). Some of the jotform questions are full sentences, which makes that column super long. is there a way to cause those row headings to be shorter? ie, could I assign a single explanatory word to each long question to populate the header of that row?

    THanks

  • jonathan
    Replied on August 11, 2019 at 7:08 PM

    Please check also our user guide : How to Integrate Forms with Google Sheets

    If I understand correctly the issue, you were referring to the google sheets column header to be too long.

    Please take note that the google sheets column headers were taken from the form field labels/names. If you want the google sheets column headers shorter, you need to edit/change first the field label/names of your form.

    Example:

    1565564831zzz 2019 08 12 07 Screenshot 10


    After you have changed the field label names, you need to redo the google sheet integration so that the changes will take effect on the Google Sheets.

    I hope this help. Let us know if you need further assistance.


  • dedmonds
    Replied on August 12, 2019 at 11:44 AM

    THank you. I know the questions are long and that is the cause. But we need the whole questions on there. I'm wondering if you are saying there's a way to name the field while keeping the question in there and the spreadsheet will only pick up the name? 


  • BJoanna
    Replied on August 12, 2019 at 12:22 PM

    The possible solution is to duplicate your form fields and add the short labels to the duplicated fields. This duplicated fields with short labels can be hidden in your live form. 

    Then with the conditional logic, you can pass the data from the fields with long labels to the fields with short labels. You can then remove the fields with long labels from your submissions page and Google Sheet. 

    How to Pass Field Value to Another Field?