-
RoxboroAsked on November 30, 2017 at 4:07 PM
Hi,
I'm trying to count the number of weeks that registers sign-up for in this form (under section 3, the big multiple choice grid with weeks listed):
https://form.jotform.com/Roxboro/day-camp-registration---summer-2018
I have other functions calculating the costs respective to the box values, but when I add a form calculator function with Count(fields), nothing happens... What am I doing wrong?
Thank you!
-
Elton Support Team LeadReplied on November 30, 2017 at 6:58 PM
In your calculation, you have already added the fields so there's no need for the count function.
Also, the count format is incorrect. It should only be count(checkboxField)
Thanks.
-
Elton Support Team LeadReplied on November 30, 2017 at 7:01 PM
Since you are using matrix field in the calculation, you might want to assign a value to each of the checkbox fields.
These values will be used in the calculation.
-
RoxboroReplied on December 1, 2017 at 9:30 AM
They are already assigned a price value so the total cost of their requested services can be calculated.
I want to use the count function to tell me how many boxes are checked. I saw it in another forum but it is not replicating to here. The count(myoptions0-9) formula from this response is what I need.. https://www.jotform.com/answers/732998-How-to-count-the-number-of-selected-check-box-options
-
Nik_CReplied on December 1, 2017 at 11:11 AM
I'm afraid that what you're trying to achieve cannot be done with Input table. You have to use checkbox field in order to calculate the number of rows:
With input table, each field acts as an independent field, so you cannot add the whole table to count function.
The only way to do the count with input table is to use calculation values as my colleague suggested above. But you're using already those for calculating the price.
I might have an idea how it would be possible.
But please allow me some time to check.
I'll get back to you.
Thank you!