Count Function not working in my calculation field

  • Profile Image
    Roxboro
    Asked on November 30, 2017 at 04: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! 

  • Profile Image
    EltonCris
    Answered 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)

    Thanks.

  • Profile Image
    EltonCris
    Answered 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.


  • Profile Image
    Roxboro
    Answered 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 

  • Profile Image
    Nik_C
    Answered 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:

    1512144308Screen Shot 2017-12-01 at 5.09

    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!