-
energyritesaAsked on October 23, 2019 at 8:33 AM
Hi
I have added some new fields to the form (Installation Form)
See ER New Fields snapshot. It seems I can only add one screenshot to this support?
I have two problems:
ONE
I have a form linked to a google sheet through Integration settings. but they are not showing in the google sheet.
How do I get the google sheet structure to change to match the form structure?
TWO
The Jotform sheets view is also now a mess.
The new fields are entered but the data has not stayed with its original field and / or fields are not in the order they are seen in the form.
THREE
As the form is tested out in the field, changes need to be made
What is the best way to deal with changes like this?
Thanks
-
Victoria_KReplied on October 23, 2019 at 9:06 AM
Hello,
Google Sheets integration could get broken if the integrated sheet was changed. Please note that we do not recommend to modify integrated spreadsheet or change its settings as this can cause the integration to fail.
Can you please re-integrate the form to google sheets? New integration should fetch all submissions fresh.
Here is related guide: How-to-Integrate-Forms-with-Google-Sheets
If you need to apply some changes to integrated sheet, I can suggest to use IMPORTRANGE function to copy the data to different sheet and apply changes to that sheet keeping original one untouched.
Your other questions will be addressed in separate threads: