-
cfabickelAsked on October 28, 2014 at 2: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?
-
Jeanette JotForm SupportReplied on October 28, 2014 at 4: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.
-
cfabickelReplied on October 28, 2014 at 5: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
-
jonathanReplied on October 28, 2014 at 5: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.
-
cfabickelReplied on October 29, 2014 at 9: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...
-
cfabickelReplied on October 29, 2014 at 9: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...
-
Welvin Support Team LeadReplied 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!
-
cfabickelReplied 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...
-
Welvin Support Team LeadReplied on October 30, 2014 at 7: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!