Google Spreadsheets Integration: Google sheets stopped updating when deleted fields

  • Profile Image
    grahamlaw
    Asked on March 27, 2018 at 09: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.

  • Profile Image
    gizem
    Answered on March 28, 2018 at 04: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.

  • Profile Image
    grahamlaw
    Answered on March 31, 2018 at 09: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.

  • Profile Image
    Kiran
    Answered 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.