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

    Generating survey reports

    Asked by sorbies on May 11, 2011 at 08:21 PM

    Hi, 

     

    Before I create a survey, I was wondering if I was able to generate a report from survey results which can then be exported to MS Excel?

     

    Thanks for your help, 

     

    Margie 

  • Profile Image
    JotForm Support

    Answered by mliz on May 11, 2011 at 09:19 PM

    Hi sorbies,

    JotForm allows you to generate reports in two formats Excel and CSV.

    Here's how to do it:

    1. Click My Forms on top of the page




    2. Click the form of which you need to get your submissions.
    3. Click Submissions above.



    4. Then click on the Exce  link.

     

    Hope this helps.

    Regards,
    Mliz

  • Profile Image

    Answered by mathetos on August 02, 2011 at 12:08 AM

    But I think the source of the question is: "What kind of data will be provided in this exported document?" Will it be a tally or average of all the scores of all the submissions? Or will it just be a database of all the submissions next to each other and all actual data analysis will have to be done by hand? Can you clarify or even post an example?

  • Profile Image
    JotForm Support

    Answered by mliz on August 02, 2011 at 01:30 AM

    Hi mathetos,

    The exported  csv/excel file will contain all of the submissions in the database
    for the selected form. This does not include any analysis or tally, its a plain output
    of all data gathered. A sample of the MS Excel report can be found here:
    https://www.jotform.com/excel/11991202562

    For analysis the of the data submitted you may use Visual Report. It can
    create percentage reports and charts from your checkbox/radio/dropdown questions.
    To create a Visual Report for a form:
    1. Login to JotForm
    2. On "My Forms" page select your form and then click "Reports"
    3. Select "Visual Report Builder" from the option

    You can find a live example of the report from this page.
    https://www.jotform.com/report/11991020482

    You can use several options for the report such as Pie, Bar and line. For further
    information on how this can be achieved please visit the page below:

    https://www.jotform.com/answers/32282-how-can-i-have-more-options-with-my-visual-report


    Hope this helps.

    Let us know if you have clarifications.

    Regards,
    Mliz

  • Profile Image

    Answered by convenus on December 12, 2011 at 07:55 AM

    I generated a Visual Report, the problem is that I only have the first 2 pies but what about all the others ? (there is no drop button) ...

  • Profile Image
    JotForm Support

    Answered by liyam on December 12, 2011 at 08:49 AM

    We have received requests regarding the visual report to increase the white space area's height due to that users find the allowable area to create the reports too small.  So far we have no updates from our developers regarding this.  For now, what you can do is simply create more visual reports by adding a new report.

    Can you also please explain further what you mean by 'there's no drop button'?  Thanks.

  • Profile Image

    Answered by convenus on December 12, 2011 at 09:21 AM

    I can not go down on the page. Maybe a full report has been generated but I can not know.

  • Profile Image
    JotForm Support

    Answered by liyam on December 12, 2011 at 09:49 AM

    If I'm not mistaken, what you did was you dragged and placed the other charts to the not-visible area.  But just to be certain, can you please tell us the ID or the URL of the form?

    The visual report can only accommodate a number of reports due to the limited space. But you can simply create multiple visual reports and place your other charts on the new one.

  • Profile Image

    Answered by convenus on December 12, 2011 at 11:31 AM

    http://form.jotform.com/form/13295852108&forceDisplay=1&prev

    Here is the URL. As you will notice the following problem occure:

    -> It's adding together different questions before displaying the outcomes, therefore distorting the results...

  • Profile Image
    JotForm Support

    Answered by Mike_T on December 12, 2011 at 04:59 PM

    Are you looking for a Chart Data DropDown to change the content of some report Element? Please take a look at the following screenshot:

    If the problem is not related to this picture, please explain the issue more detailed.

    Thank you for cooperation.

  • Profile Image

    Answered by convenus on December 13, 2011 at 07:14 AM

    URL of my form: http://form.jotform.com/form/13295852108&forceDisplay=1&prev

    I have differents charts and each one have two or more rows.

    What I need is two different graphic: 1 graphic for the content and 1 graphic for the presenter (for charts which have two rows) but 4 different graphics for those which have 4 rows, so that my results are not distort.

    The problem is that on your graphic the two rows are added (content + presenter), which makes my study completly wrong.

  • Profile Image
    JotForm Support

    Answered by liyam on December 13, 2011 at 10:31 AM

    The charts can only get results from survey field elements, individually.  Example, if you have one question that collects answers for good, better, or best, then it will only show the result from that question.  You cannot collect and graph the data of two separate questions.

    If you wish to chart the data from different questions, I can suggest that you download the excel data and use the pivot table feature.  Here are some website pages that can help you understand more about pivot tables:

    http://office.microsoft.com/en-us/excel-help/pivottable-reports-101-HA001034632.aspx 

    http://www.addictivetips.com/microsoft-office/excel-2010-create-pivot-table-chart/

  • Profile Image

    Answered by guest_23108878515055 on November 22, 2012 at 02:41 AM

    can i create a form, where at the end of it, the user's input turns into a template for the user to view?

  • Profile Image

    Answered by fxr on November 22, 2012 at 02:49 AM

    Please open a new thread for this new request giving as much detail as regards what you hope to achieve.

    Thanks