How to show content of a google spreadsheet

  • Profile Image
    A
    Asked on July 31, 2013 at 07:43 AM

    I want a basic report that shows contents of an google spreadshhet.  I have google-Jotform integration working.

    Can I do this via Joform?

  • Profile Image
    sidharth_kch
    Answered on July 31, 2013 at 08:11 AM

    Hi,

    I am not sure if I have understood your requirement.

    You can directly create a report (eg grid listing) and embed that in your form. Data in your google spreadsheet is just a copy of your submission data.

    Do you actually want to show some other google spreadsheet content in your form? You can grab your google spreadsheet embed code and embed it in your form. Please refer these guide:

    http://support.google.com/drive/bin/answer.py?hl=en&answer=55244

    http://www.bdnyc.org/2012/08/22/how-to-embed-a-live-google-docs-spreadsheet-into-a-webpage/

    Let us know if you need further assistance.

    Thanks,

    Sidharth

  • Profile Image
    gpra_forms
    Answered on July 31, 2013 at 08:51 AM

    Tkanks Sidharth

    The first option with 'gridlisting 'is good. I dont need to use google doc sheet.  I entered the iframe of grid lisiting report to my google site, however, it does not work.

    Do you know why this will be the case? jotform authentication?

    Google site where I insert  https://sites.google.com/a/student.gpra.org.au/testing/test-grid-report

    Grid list  http://www.jotform.com/grid/32113885394054

     

  • Profile Image
    pinoytech
    Answered on July 31, 2013 at 11:08 AM

    Hi,

    Sorry for the inconvenience that may have caused. With regards to your query, can you please re-embed your 'Grid' iFrame code into your website using this:

    <iframe src="//www.jotformpro.com/grid/32113885394054" frameborder="0" style="width:100%; height:100%; min-height:500px; border:none;" scrolling="no"></iframe>

    For more information, please take a look at this video: http://www.screencast.com/t/NJNpPCcSDcS

    Thank you!