Count the number of dropdown items selected

Forum|Forum|4 years ago
December 30, 2021
1 reply
1019 views

I am creating a fillable form which includes a dropdown list. The two options are "Vacant" or "Occupied". I want to be able to count the number of "Vacant" entries in a separate field. The dropdowns are named "dropdown.10" through "dropdown.31". I have tried scripts from a number of different answers to similar questions with no success. I attached two images as a reference and I can provide more information if needed. Thanks.

This topic has been closed for replies.

try67

Community Expert

You can use this code as the custom calculation script of a text field to count the number of times "Vacant" is selected:

var total = 0;
for (var i=10; i<=31; i++) {
	if (this.getField("dropdown."+i).valueAsString=="Vacant") total++;
}
event.value = total;

G

glen22450181vjmnAuthor

Participant

Try,

That script did not work for me. Could there be something wrong with my doc?

try67

Community Expert

I can't say for sure without seeing it...

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded