Count the number of dropdown items selected

Question

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.

try67 · Answer

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;

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.