How Can I Publish the Spreadsheet File on My Web Page?

  • Profile Image
    Buzzcom
    Asked on February 24, 2016 at 07:42 AM
    I would like the form to be submitted to a spreadsheet that is viewable by other users on my website. Does your spreadsheet system do this automatically and how long will the results remain online - or do I need to link to zapier to do this? Please explain further what is the best way to achieve this?
  • Profile Image
    ashwin_d
    Answered on February 24, 2016 at 11:36 AM

    Hello Buzzcom,

    Unfortunately it is not possible to send submission data directly to a spreadsheet in real time but with a little workaround, it is possible to achieve your requirement and here are the steps you should follow:

    #1. Create your desired form.

    #2. Integrate your form with google spreadsheet. The following guide should help you:  http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet 

    #3. Grab the iFrame embed code of your google spreadsheet. The following guide should help you how to grab the iFrame embed code of live google spreadsheet:  https://productforums.google.com/forum/#!topic/sites/zfgPF5l2rec 

    #4. You can use the iFrame embed code of google spreadsheet in your webpage where you want to display the submission data.

    Alternatively, you can create create "HTML Table Listing Report" or "Grid Listing report" and embed it using its iFrame embed code. When you create the report, in the report wizard only you will be able to copy the iFrame embed code.

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

  • Profile Image
    Buzzcom
    Answered on February 24, 2016 at 05:49 PM

    Thanks - very helpful.
    The only problem I am having is none of the reports are really mobile friendly.

    Is there a way with any of the report types that I can show limited information so that it fits mobile but that the rest of the information is still contained within the report if the viewer wants to access it?
    Thanks

  • Profile Image
    ashwin_d
    Answered on February 24, 2016 at 09:37 PM

    Hello Buzzcom,

    Yes it is possible to display only limited information in report. When you create a report, you can select which all form fields you want to display in report. Please check the  screenshot below:

     

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

  • Profile Image
    Buzzcom
    Answered on February 24, 2016 at 09:58 PM

    Yes I understand that I can hide fields - but are they retrievable by viewers if they want to see the rest??

     

  • Profile Image
    ashwin_d
    Answered on February 25, 2016 at 12:54 AM

    Hello Buzzcom,

    Unfortunately no. Users will not be able to see the columns which you have unchecked while creating the reports. 

    Did you try embedding the google spreadsheet method?

    Thank you!