Google Sheet integration: Integration always breaking after shared form adjustment.

  • metapon
    Asked on April 9, 2018 at 11:02 PM

    Hi there,

    Recently I have added an editor to my account. What I found is that when I link a form to a Google spreadsheet, and then that editor come in to add/remove/reorder questions then the integration breaks every time and I end up integrating to a new google spreadsheet every time. (It's annoying)

    We are currently following best practice for GG sheet integration, which is to not touch the linked spreadsheet and use =importrange instead. This works fine for my own form but not when I have other editor coming to edit


    Example form includes: 

    - Rarinjinda Consultation Card Refill

    - Spa Tablet Daily Count

    - Days off switching form

    It would be great if you could

    1) Fix the problem of integration breaking everytime when the shared form is editted (by anyone)

    2)

    Crate refresh integration button instead of having to currently break the old link and start a new sheet everytime when there is a change.

    3) Help me reintegrate Rarinjinda Consultation Card Refill to my current sheet once more. 

    Thanks! 

  • gizem
    Replied on April 10, 2018 at 4:05 AM

    We highly do not recommend editing the spreadsheet which is integrated with your form. If an integration is broken, the common reason is probably editing the sheet.

    I have manually pushed your missing submissions to your spreadsheets for mentioned forms.

    - Rarinjinda Consultation Card Refill
    - Spa Tablet Daily Count
    - Days off switching form

    I split your second request to a new thread to prevent the confusion. You can follow it here: https://www.jotform.com/answers/1439974