How would one go about getting a count of the values chosen from a drop-down list? I have 18 drop-down lists that all have the same options: Infant, Toddler, Preschool and School Age. I have a total box at the bottom for each of these areas and would like to get a count of how many boxes are filled in with each choice.
For example, if 12 boxes are chosen as Infant, 2 as Toddler, 1 as Preschool and 3 as School Age, I would like my results box to count only the 12 Infant choices and give me 12 as a result. I need to repeat this process across 3 other boxes to count the number of Toddler, Preschool and School Age choices as well, but I'm sure I can merely copy the formula over.
Here is the code I am currently using, but it counts all the fields that have any value in them, not just the ones with the Infant value.
foreach Infant in (topmostSubform.Page3[*]) do
Count(RoomAge[*])
endfor
Any help is appreciated, please let me know if you need more information.
How to count values in a drop-down list
2011-03-29 14:16:54
Answered
My Product Information:
LiveCycle Designer, Windows
LiveCycle Designer, Windows
2011-03-29 14:17:47
#1
I forgot to mention I am using FormCalc.
2011-03-30 02:19:37
#2
Hi,
this can be done with a for loop.
this can be done with a for loop.
2011-03-30 07:58:46
#3
I still cannot get it to work. I'm not terribly familiar with coding, but have dabbled in it some. I've uploaded my document to Acrobat.com. If you have time, I would greatly appreciate your time in looking at what I'm attempting.
https://acrobat.com/#d=Y1qxZHAm9nPljQe7pgg6nw
https://acrobat.com/#d=Y1qxZHAm9nPljQe7pgg6nw
2011-03-30 11:52:39
#4
Your link seems to be inactive, I cannot download your form.
2011-03-30 12:45:09
#5
It works for me when I copy/paste it. Is there a way to paste a working URL into this forum?
2011-03-30 13:09:31
#6
Make sure you have shared the form, I still get no access to it.
2011-03-30 13:14:07
#7
OK, thank you for your patience, I wasn't aware that step was necessary. It is now shared.
https://acrobat.com/#d=Y1qxZHAm9nPljQe7pgg6nw
https://acrobat.com/#d=Y1qxZHAm9nPljQe7pgg6nw
2011-03-30 22:17:52
#8
Accepted Answer
Hi,you only missed to assign the calculated value to your text field.
Just put this script into the calculate:Event.
2011-03-31 06:45:53
#9
Works beautifully now, thank you so much.
2011-04-06 19:14:36
#10
Hi I'm having a similar issue...
I'm working on a form that dynamically adds and removes rows from a table.
One of the columns in the table has a drop-down list which allows the user to select either "Phone, Fax or ADSL" as a choice of Line Type.
I need a formula to calculate the number of instances of each Line Type at the end of the user input.
I have adapted the code to the following:
var nCount = 0
for i=0 upto Row1[*].Type.all.length -1 do
if (Row1[*].Type[i].rawValue eq "Phone") then
nCount = nCount + 1
endif
endfor
$ = nCount
The code is only working for the first row in the table. Any ideas for making this work in a dynamic table?
Thanks :)
I'm working on a form that dynamically adds and removes rows from a table.
One of the columns in the table has a drop-down list which allows the user to select either "Phone, Fax or ADSL" as a choice of Line Type.
I need a formula to calculate the number of instances of each Line Type at the end of the user input.
I have adapted the code to the following:
var nCount = 0
for i=0 upto Row1[*].Type.all.length -1 do
if (Row1[*].Type[i].rawValue eq "Phone") then
nCount = nCount + 1
endif
endfor
$ = nCount
The code is only working for the first row in the table. Any ideas for making this work in a dynamic table?
Thanks :)
2011-04-06 22:13:05
#11
Hi,
you need to count the present number of rows not the number of cells.
you need to count the present number of rows not the number of cells.
2011-11-30 12:51:14
#12
I am trying to do a similar thing, but I have no idea what i am doing. I tried using the formulas you supplied in other posts, but I can't get it to pull from my drop downs. I am creating a timecard. It has 7 "Types" to choose from Regular, Holiday, PTO, etc.. for each day of the pay period. I am trying to come up with a summary of how many hours were worked in each Type.
I applied the following formula to the totals text box(nCount1). (example for Regular (type) hours)
var nCount1=0
for i=0 upto Type.all.length -1 do
if (Type[i].rawValue eq "Regular") then
nCount1 = nCount1 + 8
endif
endfor
I plan to use this formula for each totals text box for each different type. The formula has no errors, but it will not change the number when I select the drop downs.
I hope this made sense..
Thanks for any help.
I applied the following formula to the totals text box(nCount1). (example for Regular (type) hours)
var nCount1=0
for i=0 upto Type.all.length -1 do
if (Type[i].rawValue eq "Regular") then
nCount1 = nCount1 + 8
endif
endfor
I plan to use this formula for each totals text box for each different type. The formula has no errors, but it will not change the number when I select the drop downs.
I hope this made sense..
Thanks for any help.