JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Change the Google Sheet Headings.Asked by acsys on October 26, 2016 at 11:42 PM
We need to create a form that leads into a Google Sheet, but the sheet column headings need to be of a specic name.
For example if we add a date field and call this "Date of Birth" on the form, we need to this to fill in a column called "DOB" on the Goolge Sheet. Currently the column is the same name as the visible form feild name.
I have tried to change the Unique name in the Advanced Field options but this does not work.
How do we do this?
Unfortunately you cannot change the headers on the google sheet without having to change them on jotform. The column header name in the integrated Google spreadsheet is based on the field's label name. Changing the header on the spreadsheet without changing the form field's label name will cause the integration to break.
A possible workaround I can suggest would be to create another Google Spreadsheet with your preferred headings. Then use the ImportRange function to copy the data from the integrated google sheet into the google sheet that you created.
You can follow this guide on How To Import Data From Other Google Spreadsheets.
Please let us know if you need further assistance.