Feature request: google spreadsheet integration

  • Profile Image
    yachtboy
    Asked on February 05, 2012 at 03:07 PM

    I know this has been requested numerous times already but I want to repeat the request for Google docs integration. 

  • Profile Image
    fxr
    Answered on February 05, 2012 at 04:22 PM

    Yes, its already on the developers (rather long) list. 

    I havent tried this myself, but one of users suggested a workaround that you could possibly make use of:

    ---

    @Hello,

    I seem to be able to automatically upload my form submissions into google spreadshets.

    I employ the =importhtml function to grab the HTML Table Report from Jotform.

    Below are two examples.  The first simple example updates more slowly, up to an hour between updating.  The second example,  employs google finance functions to force the spreadsheet to update every two minutes.  The second example does add a disclaimer to the spreadsheet about stock quotes because using the google finance function triggers this disclaimer.  Of course, I doubt you will actually be storing stock quotes in your form.

    Furthermore, in the second option you can change the number, highlighted in yellow below, to choose how often, in minutes, the spreadsheet updates.  It is set to every two minutes, below.

    Replace the green highlighted area with the URL of your form report after making an HTML Table Report.

    To get started copy one of the options below and paste it into a blank google spreadsheet in cell A1, for example.  Be sure to change the table # to the # of your form report.  The data should load into the spreadsheet.  Good luck!

     

    =ImportHTML("http://www.jotform.com/table/###########"; "table";1)

     

    =ImportHTML("http://www.jotform.com/table/#########" &"?workaround="&INT(NOW()/TIME(0;2;0))&REPT(GoogleFinance("GOOG");0) ; "table";1)

     

    ---

     

    Maybe that will be of some use to you? Le us know how you get on if you do decide to experiment with it. 

  • Profile Image
    yachtboy
    Answered on February 13, 2012 at 09:04 AM

    Thanks, I got that working.  It wouldn't be hard for you to have a link on your sharing section that spit out the formula with the correct table number ready for copy-and-pasting into a google spreadsheet.

  • Profile Image
    mtlee27
    Answered on February 15, 2012 at 03:09 PM

    I really like this solution!  Have you experienced any issues with stability?  I had it working in my Google Spreadsheet yesterday and now I can't get the same function to work.  I have tried creating new tables, new sheets and even tried in a brand new spreadsheet.  This is a deal breaker for me as my solution revolves around Google Spreadsheets.  Just curious if you had seen any issues long term with this solution?  

    I have tried another form builder which doesn't support google spreadsheet very well and I have also tried lanbito but it isn't NEAR as functional of a form builder (though the forms are definitely more mobile friendly)...no conditional forms etc...Jotform is definitely the best overall solution for features, price, flexibility...I hope they haven't removed this ability?

    Any help or thoughts would be appreciated! 

    here is my table

    http://www.jotform.net/table/20451434140

  • Profile Image
    yachtboy
    Answered on February 15, 2012 at 07:11 PM

    I would give the jotform team a few days to sort out the giant mess our idiotic government has handed them and then try it again...it's amazing to me that things are working as well as they are!

  • Profile Image
    mtlee27
    Answered on February 15, 2012 at 07:17 PM

    I am not sure I understand, what have they done now?  Amazingly it started working again.  

  • Profile Image
    aytekin
    Answered on May 07, 2012 at 01:02 PM

    UPDATE: We have now released integration with Google Docs:

    http://www.jotform.com/blog/57-Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-

    You can get your submissions directly in a Google Docs Spreadsheet. Please give it a try and if you have any further comments or suggestions, post it on the blog post comments.