- sasa999Asked on March 18, 2013 at 04:05 AM
Your original Google spreadsheet integration is dead - http://www.jotform.com/answers/191293-Conection-to-Google-spreadsheet?&&updatemessage=10732640770
As I understand, your solution will be a long wait
Can be used ImpotHtml for Google Spreadsheet to retrieve data from a table that is at the bottom of submissions page?
like for reports I use =ImportHtml("http://www.jotform.com//table/30742754061046","table",1)
I was try this, but it does not work. Show error
Maybe wrong url adress or index?
- JotForm SupportEltonCrisAnswered on March 18, 2013 at 05:58 AM
That's not possible with submissions page probably because google thinks it as a secure page and needs authorization. I would suggest creating an HTML table report instead. Here's a guide: Create an HTML Table Listing Report. After that import it like this way.
Simply replace the highlighted URL to your table report URL. Thank you!
- sasa999Answered on March 18, 2013 at 06:52 AM
How to use ImportHtml for public shared submissions page http://www.jotform.com//submissions/30715297090353
=ImportHtml("http://www.jotform.com//submissions/30715297090353"; "table";1) - show error :(
- JotForm SupportEltonCrisAnswered on March 18, 2013 at 07:49 AM
Sorry I just made a search and ImportHtml can only detect table or list tag from an HTML source of the page so it is not possible to use JotForm submissions. JotForm submissions grid listing 'table' is not created with simple HTML table tags, it runs on a customized code for special functions like search and etc. So as previously mentioned, you have to create an HTML Table Report and use it for Google Importing.
I hope this clarifies a bit. Thank you!