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

    Summarizing the submitted data

    Asked by Triacees on April 29, 2015 at 02:26 PM

    How can I summarize the data that is submitted via a form?

    I have made an investigation form with several questions which have those answer possibilities: 'yes', 'may be' and 'no'.

    Is there a way to count the 'yes'-answers as well as those with 'no' and 'may be'?

    Sure, I can make an excel table with some formula's that wil do the job, but I wonder if Jotform has such capabilities.

    submitted data JotForm excel count
  • Profile Image
    JotForm Support

    Answered by jonathan on April 29, 2015 at 05:16 PM

    To be able to achieve the summary you wanted, you will need up to 2 option answer only (i.e YES or NO only... exclude Maybe)

    You will need the Count function and Calculation widget to achieve this. It can be done using the Checkboxes as it has the Count function needed.

    Here is an example form http://form.jotformpro.com/form/51186423928965?

     

    As you can see on the demo form.. if checked = Yes, unchecked = No. You can summarize then the difference.

    As you mentioned already, if you need to do a more complex summary, you can always use the Submission Data spreadsheet result, and create the summary using spreadsheet/excel function.

    Hope this help. Let us know if you need further assistance on this.

    Thanks.