Classic Forms/Google Spreadsheet: Connection breaks after modifying form (adding/removing fields).

  • Profile Image
    mrdamgoode
    Asked on March 29, 2018 at 01:15 PM

    Hi there, I have my submission results exporting automatically to a google sheet.  I made a couple changes to the form itself and it stopped sending information to the google doc.  I was able to "Remove Integration" and restart it, but it saved to  different spreadsheet.

    Is there a way to make changes to a form and have the google spreadsheet update automatically?

  • Profile Image
    Kiran
    Answered on March 29, 2018 at 02:16 PM

    Generally, if the existing fields on the form are updated, the spreadsheet shall also be updated automatically. Could you let us know what changes you are making to the form? Making any changes to the integrated spreadsheet would break the integration. 

    Also, please note that each time Google spreadsheet is integrated, it creates a new spreadsheet and the old spreadsheet will not be updated.


  • Profile Image
    mrdamgoode
    Answered on April 10, 2018 at 01:39 PM

    I added some fields to the jotform and it stopped updating the google spreadsheet.

    I have been able to add tabs to the target google spreadsheet without breaking the integration.

  • Profile Image
    Kevin_G
    Answered on April 10, 2018 at 02:21 PM

    Yes, fields either removed or added after setting up the integration will not be reflected on the spreadsheet, I have noticed that the integration breaks as well after doing any change on the form. 

    I will pass this over to our second level so our developers can have a look on this, we will keep you updated via this thread. 

    Also, note  that as explained by my colleague before, modifying the spreadsheet may break the integration, we do not have an accurate list of changes that may break the connection, but we do recommend to avoid making changes on it. 

    Thanks.