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

    why is report showing all items checked on form in one box on excel

    Asked by cfabickel on October 28, 2014 at 02:53 PM

    I have a form built that requires user to check boxes... when I run a report then everything that is in that question that has a box checked shows up in one cell in excel report... ??? how can this be stopped and each box checked show up in the report on a separate cell?

    Page URL:
    http://form.jotformpro.com/form/43004581402947

    Screenshot
    excel checked items calculation value tabulation compute value
  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on October 28, 2014 at 04:28 PM

    A better alternative would be to use matrix (under Survey Tools) and change the input type to Check Box, that's the only way you'll get the options in separate cells.

  • Profile Image

    Answered by cfabickel on October 28, 2014 at 05:08 PM

    tired this but I "HAVE" to be able to require at least and no more than a certain amount... I want to use this for voting purposes and football coaches are not very smart... :)  I need a way to count and tabulate... I can do that on excel but I need each check box in its own cell

     

  • Profile Image
    JotForm Support

    Answered by jonathan on October 28, 2014 at 05:52 PM

    Hi,

    It is not clear what you wanted to achieve here.

    But base on this statement..

    but I "HAVE" to be able to require at least and no more than a certain amount... I want to use this for voting purposes and football coaches are not very smart... :)  I need a way to count and tabulate...

    I think the main objective is to Calculate  a result base on checked items/options

    You CAN achieve the counting and tabulation of the results by using Calculation in the form.

    Check this user guide: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    In your checkboxes options you can assign Calculation Value for each option.

    The calculation values can then be tabulated/counted using Calculation.

     

    Here is a demo jotform http://www.jotform.me/form/43006549165454 you can try.

     

    Inform us if this can work on your requirement or not.

    Thanks.

     

     

     

     

     

     

     

  • Profile Image

    Answered by cfabickel on October 29, 2014 at 09:12 PM

    I am not sure how this calculation would work for me... I need to calculate based on submissions not choices made on one form but many forms that are submitted.  Here is an active ballot I made up...  As you can see if I ask for 5 votes minimum on a question with 10 possible answers... what I get with your form is the 5 choices made all packaged together in one cell...  I added DOTs to the info for the question basically so I can use excel and delimit the cell somewhat... the dots actually separate the words somewhat so I can extract the data into multiple cells ... 

     

    I need to be able to sum up the submissions though not the choices on one form...

  • Profile Image

    Answered by cfabickel on October 29, 2014 at 09:14 PM

    also, if I ever wanted to use this calculation option how do you see the calculations then and actually use it.. the image you gave me is much appreciated but I don't understand the values you entered and how its used...

  • Profile Image
    JotForm Support

    Answered by Welvin on October 29, 2014 at 11:10 PM

    A workaround I could think to accomplish this is to use COUNTIF Function in g.excel sheet. Here's how for example: 

    https://support.google.com/docs/answer/3093480?hl=en

    http://spreadsheets.about.com/od/otherspreadsheets/qt/090804-google-spreadsheets-countif.htm

    ' your thoughts?

    Thank you!

  • Profile Image

    Answered by cfabickel on October 29, 2014 at 11:18 PM

    I think you guys are missing my point... since all of the results are all in one cell for each voting item how would this COUNTIF Function work?  A survey table would have worked but only if I could set preferences to require a min and max of checks as you can see I did on the check box one...

     

  • Profile Image
    JotForm Support

    Answered by Welvin on October 30, 2014 at 07:16 AM

    Here's an example: https://shots.jotform.com/welvin/userfile/12.xlsx (for column L). You can see the output in the result tab.

    If you will use this method, you have to remove the dots in the option and leave it a separate one so we can just wrap it and use this COUNTIF function.

    The formula:

    =COUNTIF(Submissions!$L$2:$L$6000,"*" & A2 & "*")

    L stands for Column L in the Submissions tab. A2 is the column which results are search and tallied (result tab).

    Let us know if you are confused and needs some clarification.

    Thank you!