What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How to count the number of filled in dropdown field?Asked by stormingrobots 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:
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.
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.
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.