How to count the number of filled in dropdown field?

  • Profile Image
    stormingrobots
    Asked on January 23, 2017 at 05:34 PM

    I have 8 selection boxes.

    Each one has 3 to 5 choices, but only one can be picked.

    I put in a condition to count # of selection boxes actually have picked a selection.

    unfortunately, strange value added in . 

     

    Take an example:

    https://www.jotform.com//?formID=70208611384148#design

    Scroll down, you will see 8 different weeks . Each week has 3 to 5 choices with only one selectable.

    In the criteria selection. I add 1 into a number field called "Number of weeks enrolled"  for each is filled with answer.  Strange number showed up. It is almost like it is added the order of the entry instead on just "1" as I have mentioned in the criteria set up.

     

    Advice?

     

    //..update.. 

    never mind that...  my mistake is doing self-incrementation.    My issue is really " 

    How can I count the number of dropbox being filled.  I'll post another thread as this is really another question. 

     

  • Profile Image
    ashwin_d
    Answered on January 23, 2017 at 11:19 PM

    Hello stormingrobots,

    So you want to count the number of dropdown which is filled. Is that correct?

    Though you cannot get the count but it is possible to check if any particular dropdown is selected by taking advantage of "Conditions" feature. With a little workaround it is possible to achieve your requirement. Here are the steps we should follow:

    #1. Add one hidden textbox for each dropdown field.

    #2. Add condition to check if the dropdown is selected/filled and add the value in textbox. The following guide should help you:  https://www.jotform.com/help/268-Conditional-Logic-Inserts-Text-Calculation-Into-A-Field 

    #3. Repeat the step #2 for each dropdown and hidden textbox.

    #4. Add "Form Calculation" widget to show the sum of all hidden textboxes. 

    Please take a look at the following demo form I created for you and see if this is what you wanted to achieve: https://form.jotform.com/70229204718958

    Feel free to clone this form for a closer look. The following guide should help you in form cloning:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!