- anthonyaramdassAsked on August 01, 2013 at 12:38 PM
The Google Spreadsheet integration is not syncing automatically. It will sync once but it won't synchronize when new submissions are received.
- sidharth_kchAnswered on August 01, 2013 at 02:10 PM
My apologies for the inconvenience this has caused.
I cloned your form and did few test submissions. I was able to reproduce this issue. I am creating a ticket and forwarding this issue to our development team. We will update you via this thread.
Would using the HTML listing report be an alternative? This report updates automatically with every submission. It can be embedded on a page or a form.
Here is a guide to help you with that meanwhile the integration issue is resolved.
- anthonyaramdassAnswered on August 01, 2013 at 02:52 PM
Thank you for replying. Would I be able to sync this to a google spreadsheet by any chance?
- sidharth_kchAnswered on August 01, 2013 at 03:21 PM
Yes absolutely. This issue is already forwarded to our development team. Please stand by for updates from them.
- JotForm FounderaytekinAnswered on August 02, 2013 at 11:25 AM
Do you still have this problem? It might be a temporary problem on our server or google's end.
- anthonyaramdassAnswered on August 02, 2013 at 06:23 PM
I created the HTML Table but how can I see the submissions as a google doc using the embed code or weblink?
- AlhambraAnswered on August 03, 2013 at 02:37 AM
[correction to my previous comments] it still looks like a problem, but not really. I waited well in excess of 10-15+ mintues and no updates, but now I see the spreadsheet is updating. And now it updates instantly.
I love what you guys are doing with the GDocs Spreadsheet integration.
Also, it would be great to hear what functionality we should expect out of this otherwise amazing feature - is there any more documentation?
For example, I found that as long as we do not change the label in the header row, I could add/move columns and it would update: As long as the header row had the original name.
Thanks for a great product!
Alhambra Capital Advisors
P.S. Thanks, Sidharth, for the HTML listing heads up! I did not notice that feature until I was debugging my spreadsheet integration and came across this thread.
- JotForm SupportWelvinAnswered on August 03, 2013 at 07:19 AM
Are you "anthonyaramdass"? Is that a separate account? I hope that it will continue to work without any problem. If the issue occurs again, please be sure to let us know by creating a separate thread.
We only have one guide for the Google Spreadsheet Integration. We don't have further articles that would itemize each options for the integration. You can always come back to us for your questions. We're here 24/7.
Also, you can search our Forum. One of your question may have been answered by the team.
- anthonyaramdassAnswered on August 03, 2013 at 10:23 AM
No, that is not me. That's someone else's account.
- anthonyaramdassAnswered on August 03, 2013 at 11:25 AM
Ok, I see that the google spreadsheet works. It just takes a bit of time to refresh. My question is, if I format the header and freeze that row, would it affect the integration?
- jefreylandichoAnswered on August 03, 2013 at 12:17 PM
Modifying the Google spreedsheet could make the integration not to work so I would not recommend changing anything in your Google Spreedsheet.
- CoachMyRodeoAnswered on August 04, 2013 at 10:48 PM
- AlhambraAnswered on August 04, 2013 at 11:57 PM
I recommend checking out my response above and some testing on your own before giving up entirely on the formatting changes/column re-arranging. I've had success in my testing. Just don't insert a row at top; don't change the text in the first row of the linked column.