Can I insert an iFrame into the form to display a Google Spreadsheet?

  • Profile Image
    ahinch
    Asked on October 10, 2013 at 11:23 AM

    Hello - 

    I'm creating a request form, and I'd like to display a spreadsheet of requests within the form. I have a published spreadsheet and the iFrame HTML - I just cant get it to display on my form.

     

    Any thoughts?

    Thanks-

     

    Andy

  • Profile Image
    EltonCris
    Answered on October 10, 2013 at 12:04 PM

    Hi Andy,

    Have you tried embedding the iframe code using Free Text HTML? It should work.

    If that doesn't work, use your form source code. How to get your Form Source Code.

    Let us know if you need further assistance. Thanks!

  • Profile Image
    ahinch
    Answered on October 10, 2013 at 03:49 PM

    Yeah - I tried to paste the iFrame code from my spreadsheet into that Free HTML window. I've succesfully embedded other objects into jotforms the very same way - it just doesnt want to show my google spreadsheet.

     

    Maybe I'm going about it wrong. I'm trying to create a service request form that displays a live spreadsheet. The speadsheet would be updated manually by myself, but would show users who/how many people are in line ahead of them - AS they're filling out the form.

    Does that make any sense?

    Thanks!

    -Andy Hingtgen

  • Profile Image
    EliezerN
    Answered on October 10, 2013 at 06:05 PM

    Thanks for contacting us.

    I just tried to insert an Google spreadsheet to my form using the Free Text (HTML) feature and I had no issues:

    This is my form: https://www.jotform.com/form/32827255061957

    I used this code to insert in the Free Text (HTML):

    <iframe id="JotFormIFrame" onload="window.parent.scrollTo(0,0)" allowtransparency="true" src="ENTER HERE YOUR SPREADSHEET URL" frameborder="0" style="width:100%; height:465px; border:none;" scrolling="yes"></iframe>

    Use that code, you can edit the width and the height to fit your needs. Let us know if that works or if you need further assistance.

    Thanks