ImportHtml for submissions table

  • Profile Image
    sasa999
    Asked 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

    so

    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

    =ImportHtml("http://www.jotform.com//submissions/30715297090353","table",1)

    Maybe wrong url adress or index?

  • Profile Image
    EltonCris
    Answered on March 18, 2013 at 05:58 AM

    Hi,

    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.

    =ImportHtml("http://www.jotform.me//table/30414563256046"; "table";1)

    Simply replace the highlighted URL to your table report URL. Thank you!

  • Profile Image
    sasa999
    Answered 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 :(

  • Profile Image
    EltonCris
    Answered on March 18, 2013 at 07:49 AM

    Hi,

    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.

    Create an HTML Table Listing Report

    I hope this clarifies a bit. Thank you!