- RoxboroAsked on November 30, 2017 at 04:07 PM
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):
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?
- JotForm SupportEltonCrisAnswered on November 30, 2017 at 06: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)
- JotForm SupportEltonCrisAnswered on November 30, 2017 at 07: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.
- RoxboroAnswered on December 01, 2017 at 09: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
- JotForm SupportNik_CAnswered on December 01, 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.