Calculate the total of dropdown value selected

[MINT TEE]

Hi

I am creating a inspection report, with a list of inspection items. At the side of each items, I have a dropdown list of Pass, to be rectified, N.A. At the end of the report, I want to show the total number of "Pass" selected, "to be rectified" and "N.A". I only need to know how many passes are there, how many "to be rectified" are selected and so on. How can I do that?

[try67 · Accepted solution]

OK, then you can use this code as the custom calculation script of the field that counts the number of "Pass" selections:

var total = 0;
var fields = this.getField("Dropdown3").getArray();
for (var i in fields) {
	if (fields[i].valueAsString=="Pass") total++;
}
event.value = total;

Simply adjust the string in the fourth line to re-use it for the other values.

[try67]

What are the names of those fields?

[MINT TEE]

Pass, Rectified, to be rectified, N.A. In the dropdown list also these 4 items.

[try67 · Accepted solution]

OK, then you can use this code as the custom calculation script of the field that counts the number of "Pass" selections:

var total = 0;
var fields = this.getField("Dropdown3").getArray();
for (var i in fields) {
	if (fields[i].valueAsString=="Pass") total++;
}
event.value = total;

Simply adjust the string in the fourth line to re-use it for the other values.

[MINT TEE]

It works now. Thank you so much.

[MINT TEE]

Hi @try67 , does the script work on iOS app? It doesn't seem to work when I use it on my mobile app.

[Nesa Nurani · Accepted solution]

Only some basic JavaScript functions works on mobile devices, so this script won't work, you can try "PDF Expert" app by Readdle for iOS it has more support for JavaScript.