- regalwingsAsked on February 22, 2018 at 10:36 AM
According to what I see, your Google sheets integration is very primitive and disappointingly inadequate. I often update the fields on my form, and the google sheet with the info is in turn integrated with other parts of our data system. So... every time I need to reintegrate, it turns into a huge pain in the neck, and i need to do many updates across my system. I find it hard to believe that you really have any plans to ever take care of this. Seems pretty obvious that it's a very requested feature. Also pretty convinced that this is very doable on your end... if you just put your mind to it. Why can't you just do this already? Please don't answer anything less than a real explanation that will make us understand, and not just give us a push off answer. thanks.
- MarvihAnswered on February 22, 2018 at 12:09 PM
We understand your frustration regarding this matter. Making changes on your form field does NOT literally break the integration with your Google Spreadsheet Integration and you should still be able to receive new submissions on the sheet.
One of the main reason the Google Spreadsheet Integration breaks is when you modify the Column Headers on the sheet or Google updates their Authentication token. Same when you delete a Column on your spreadsheet then it will stop receiving new submission since the integration will be broken.
As much as possible prevent any changes from the Spreadsheet itself so that the integration will not break.
If you constantly modify your Form, what I can recommend is to have another Sheet and use the Import Range function so all data that comes in from the Google Spreadsheet integrated with your Form will be imported/copied to the new Sheet that you added.
This way you can modify the new Sheet and use it in Integrating other parts of data on your system and just make the Integrated Sheet from the form the landing sheet for your form submissions.
I hope this helps, please let us know if this doesn't work for you.
- regalwingsAnswered on February 22, 2018 at 12:37 PM
Thank you for your prompt response.
Indeed, I already use the import range as you suggested.
The problem is, that every time I add a new field on the form, the new field doesn't populate on the integrated sheet. so what i need to do is reintegrate it, then go and find and replace the sheet code every place the import range is referenced. what's more, it moves over the columns, so for instance if a column was called "date" and i inserted a new field on the form before that column, the "date" column on my import range has now shifted to the column next to it and is no longer giving me the 'date' info.
Another issue: if i delete a record in the jotform database, the record stays on the google sheet forever and doesnt sync (which makes for terrible record keeping and clutter). deleting it on the sheet causes the integration to break. (this happened a few times. sometimes it breaks the integration completely, and more often what it does is that from then on all new records get added to the top of the sheet on top of the column headers, which messes up the entire structure)
still trying to figure out why you cant do a more robust integration like so many other software designers do.
- MarvihAnswered on February 22, 2018 at 02:00 PM
Thank you for getting back to us with additional information about the issue you are having.
I will escalate this to our Developers and see if they are able to provide solution or fix to your issues.
For now what I can think to view your submission data with live update is by creating a Report (Excel,CSV, HTML, Grid Listing and more).
Although I am not sure if this would be of any help for you. We will make sure to update you if there are new update with our Google Integration.
Sorry for this inconvenience.
- JotForm DevelopergizemAnswered on March 15, 2018 at 07:54 AM
I have split your problem into a new thread to prevent any possible confusion. You can follow it here: https://www.jotform.com/answers/1415855