Count Function not working in my calculation field

  • Roxboro
    Asked 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 Lead
    Replied 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.

    Count Function not working in my calculation field Image 1 Screenshot 20

    Also, the count format is incorrect. It should only be count(checkboxField)

    Thanks.

  • Elton Support Team Lead
    Replied 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.

    Count Function not working in my calculation field Image 1 Screenshot 20


  • Roxboro
    Replied 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_C
    Replied 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:

    1512144308Screen Shot 2017 12 01 at 5 Screenshot 10

    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!