- KickUpAsked on March 06, 2018 at 09:14 AM
We've noticed a new and unexpected behavior that's super disruptive, and I'm hoping there's something we can do to fix it to align with the previous, expected behaviors.
With the Google Sheets Integration, it used to be that the integration only broke (stopped pulling in new submissions) if you made significant/structural changes to a survey. We often make minor updates to our forms - like adding new options to drop-downs (without changing the integrity/column structure of a survey), expecting the Google integration to continue to work. It's extremely important that it continues to flow into that same spreadsheet that we set up, because we then use that spreadsheet url in other places to manipulate the data in other ways.
It seems - as of recently - that even the simple act of adding a new option to a dropdown breaks the integration (responses stop pulling in).
We really rely upon the previous behavior (as I'm sure other Jotform users do), and are wondering if there's anything that can be done to avoid this.
Thanks for your help!
- JotForm SupportAdrianAnswered on March 06, 2018 at 10:25 AM
Unfortunately, making changes to the form will mean that the integration with Google Spreadsheets will most likely break. However, adding a new option to a dropdown should not break it. I have just tested this.
If you are not receiving submissions to the Spreadsheet after making a change, you would need to remove the integration and add it again to continue receiving new submissions to the spreadsheet.
Making direct changes to the integrated spreadsheet itself will break the integration as well.
- KickUpAnswered on March 06, 2018 at 10:43 AMThanks, I understand what to do when the integration breaks - (though it's
difficult to just re-integrate often because we then have to update that
new spreadsheet url in many different places) - so, we were hoping to avoid
having it break so easily. It's good to hear that it shouldn't be breaking
from updates to drop-downs - I had thought we'd seen that behavior.
- JotForm SupportVictoria_KAnswered on March 06, 2018 at 12:11 PM
From what I can read at your last post, I can not be sure if you're experiencing Google Spreadsheet integration break or not. Can you please clarify what do you mean by
"I had thought we'd seen that behavior"?
- KickUpAnswered on March 06, 2018 at 01:43 PMTo clarify - we have definitely seen this behavior in the past. But, if
that is not the intended behavior, we'll need to do some testing to figure
out if that's happening every time or if there are certain circumstances
that throw off the integration.
- JotForm SupportAdrianAnswered on March 06, 2018 at 01:58 PM
As I said earlier, adding new options to a drop-down element or similar should not break the integration.
I am not aware of all the cases when the integration will break but it will most likely break if you add a new field/element.
Also, if you need to work with the spreadsheet, please clone it. Working directly on the integrated sheet can break the integration as well.
We are sorry for any inconvenience caused.