Jotform Sheets and Google sheets not updating with new form fields

  • energyritesa
    Asked 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

    Jotform Thread 2011545 Screenshot
  • Victoria_K
    Replied 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:

    https://www.jotform.com/answers/2011603 

    https://www.jotform.com/answers/2011602