Google Spreadsheets Integration: Google sheets stopped updating when deleted fields

  • grahamlaw
    Asked on March 27, 2018 at 9:49 PM

    I enabled Google Sheets integration for this form: https://www.jotform.com/grahamlaw/telephonic-scheduling-form

    I understand that not all fields are needed, so I deleted one field, and the sheet still updated. I then deleted several fields, and the sheet stopped updating when new forms were submitted.

    Thanks, Carl.

  • gizem
    Replied on March 28, 2018 at 4:23 AM

    Hello Carl,

    Google spreadsheet integration can be broken when you made changes on your form or the sheet.When you change something on the form, you need to integrate the spreadsheet again.

    I cloned your form to my account and integrated with my Google spreadsheet. It worked fine. Please try to remove the integration and add it again.

    I hope this helps.

  • grahamlaw
    Replied on March 31, 2018 at 9:42 AM

    OK, I figured this out. I can delete any column except for the submission ID - deleting that stops new data from appearing, but upon undoing the delete, all new submissions work fine again.

    Carl.

  • Kiran Support Team Lead
    Replied on March 31, 2018 at 10:28 AM

    We do not recommend making any modifications to the integrated spreadsheet and deleting or making any modifications to any field could break the integration. Glad to see that the spreadsheet integration is working fine on your form. 

    Please get back to us if you need any further assistance. We will be happy to help.