How can I calculate how many text drop down fields contain an "S" in a form?

Question

I have fields numbered 1-83. In each of these fields people can choose an S, NI, or U. I'd like to enter a calculation in field total S, total NI, total U that will count how many of each these employee received.

What is the suggested calculation and where do I enter it?

Thank you in advance for your brilliance.

try67 · Accepted Answer

Here's my CTRL J response:TypeError: this.getField("Dropdown" + i) is null3:Field:CalculateThat means one of the fields is not named correctly. Try this code:var total = 0; for (var i=1; i<=83; i++) {  var fname = "Dropdown"+i; var f = this.getField(fname); if (f==null) { console.println("Error: " + fname); continue; }  if (f.valueAsString=="S") {  total++;  } } event.value = total;

try67 · Answer

As the custom calculation script of the "total S" field, enter something like this (I'm assuming the drop-down fields are named "Dropdown1", "Dropdown2", etc.):

var total = 0;
for (var i=1; i<=83; i++) {
    if (this.getField("Dropdown"+i).value=="S") {
          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.

Scanning file for viruses.

This file cannot be downloaded