- idanfactorAsked on May 13, 2012 at 02:22 AM
The integration with google spreadsheets is amazing!
Jotform is such a brilliant tool.
With great power come great problems:
I noticed that when I edited the data in the integrated spreadsheet it was stopped from being updated,
One thing is for sure: Google spreadsheet was stopped of being updated.
What is the exact reason and how I can solve it?
- gori-mathewAnswered on May 13, 2012 at 03:15 AM
We sorry for what this issue has caused you. Unfortunately, you can not change/edit data in the spreadsheet and still have the data being imported. You will have to make changes of either the through JotForm.
Can you try to remove the integration and re-integrate it again. Try it out and lets know if this works.
For more guidelines, please read on; http://www.jotform.com/blog/57-Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-
Please also lets know the Form's URL to have alook at it and see if we can find a workaround.
- idanfactorAnswered on May 13, 2012 at 03:29 AM
Thanks, I think you should consider to change this feature and allow to spreadsheet to update after editing...
- JotForm SupportliyamAnswered on May 13, 2012 at 05:25 AM
We apologize for this. Currently, what happens on my end is that an edited submission turns out to be a new submission in google spreadsheet. Is this what's happening to yours now?
I will let the development team know about this. As soon as we have updates, we'll let you know immediately.
Thanks for your patience.
- NieboyAnswered on June 12, 2012 at 11:19 AM
yes please, I have been struggling with this too. I am making changes to my form and it is causing the original form to be ignored and I have to re-integrate google docs which creates a duplicate speadsheet in goole docs (drive :)). I have a relatively complex sheet added to the origonal submissions sheet and I need to cut and paste the old sheet over to the new submissions spreadsheet.
I can see the problem with editing the main submissions sheet from within google, but if the form is changed on Jotforms side then I think it should update the speadsheet in google docs.
I will be patiently waiting for a update, until then I will need to cut and paste and delete the old spreadsheet i suppose.
- jnilesAnswered on July 27, 2012 at 03:36 PM
I was experiencing the same issue, the Google Docs didn't update when I had made changes to the form. Also, we need to add additional columns to the Google Docs that doesn't appear on the form but is used by our department internally to track the submission requests, is there a way to add a feature/function to parse/import original Google Docs from JotForm to another Google Docs to keep both updated docs updated dynamically real time? Any tips would be greatly appreciated.
- EngPairedAnswered on July 27, 2012 at 04:09 PM
I have also had problems with this. It is also discussed in this thread:
I ultimiately decided to abadon using the google Docs integration for forms that I knew would still change and instead use the Google Doc function importHTML to import my data from an html table report. (i.e. use =importHTML("http://www.jotform.com/table/210941800600XX", "table", 0) ).
This is a pretty complex way to achieve what is much easier with the integration, but it gives you more control and you can change your form all you want and it will keep importing to the same sheet.
- jnilesAnswered on July 27, 2012 at 04:19 PM
How do I obtain my form's jotform url table?? I see something like this when I view my form data in JotForm http://www.jotform.com/submissions/21986584624xxx
- EngPairedAnswered on July 27, 2012 at 06:21 PM
The HTML table is generated as a report for the form. So select the form, go to reports, add new report, and select HTML table. When you make that report it will give you the url for the table.
As I'm writing this though, the thought occured to me that I'm not sure that report updates automatically if you change the form either. I know that most reports will NOT update to add new fields so you have to explicitly go back and regenerate the report. Again, I believe the mentality here is that once you have a form and people start using it you aren't planning on changing it. I personally find that philosphy inadequate for the way I am using the tool, but perhaps it is true for many users.
- JotForm SupportliyamAnswered on July 28, 2012 at 09:28 PM
Thanks for responding to jniles, EngPaired.
To answer your question, remember that we select the fields that we wish to appear on our reports? So this means that by default, these new fields added when you edited your form are unchecked in the reports wizard. You will need to edit the report, tick the checkbox, and continue the end of the wizard for it to be saved and for it appear on the report page.
So there is no need to regenerate the report, just edit your report and check the new field will do fine.