- Templates
-
Integrations
- INTEGRATIONS
- See 100+ integrations
-
- FEATURED INTEGRATIONS
-
PayPal
-
Slack
-
Google Sheets
-
Mailchimp
-
Zoom
-
Dropbox
-
Google Calendar
-
Hubspot
- See more
-
Products
- PRODUCTS
-
Form Builder
-
Jotform Enterprise
-
Jotform Apps
-
Store Builder
-
Jotform Tables
-
Jotform Inbox
-
Jotform Mobile App
-
Jotform Approvals
-
Report Builder
-
Smart PDF Forms
-
PDF Editor
-
Jotform Sign
- FEATURES
- Jotform Teams
- Enterprise Mobile
- Prefill Forms
- HIPAA Forms
- Secure Forms
- Assign Forms
- Online Payments
- Widgets
- See more features
-
ENTERPRISE
-
Read use case
&
JOTFORM ENTERPRISE
- FEATURES
- Multiple Users
- Admin Console
- White Labeling
- See more
- SOLUTIONS
- Healthcare
- Education
- Non-profit
- Contact Sales
Can i change google sheet colum header without breaking the integration?
-
Martin LuckAsked on August 30, 2022 at 03:48 PMHello, Can I change the Google Sheets column header titles once the integration of my jotform has taken place. For example the Name on GS has shown as Label 1 or similar?
I's rather it were called Name? Thanks
This is a re-post of a comment on How to Integrate Forms With Google Sheets
-
HarveyAnswered on August 30, 2022 at 06:02 PMJotform SupportHi Martin,
Thanks for reaching out to Jotform Support. 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.
Give it a try and let us know how it goes.
