What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by Buzzcom 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
    JotForm Support

    Answered by ashwin_d 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

    Answered by Buzzcom 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
    JotForm Support

    Answered by ashwin_d 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

    Answered by Buzzcom 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
    JotForm Support

    Answered by ashwin_d 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!