Add up values when the check box is selected

Question

I have a form that I am trying to sum up a total of seven lines, but only have them total if the check box next to the value is clicked. How do I do this?

I do not have them in a table, this is just for easy display of the form I created.

TABLE Example:

CHECK BOX	ITEM	VALUE
X	ITEM1	1
X	ITEM2	1
X	ITEM3	1
X	ITEM4	1
X	ITEM5	1
X	ITEM6	1
X	ITEM7	1
DOES NOT HAVE CHECK BOX, JUST A SUM OF CHECKED BOXES	TOTAL	SUM OF ABOVE LINES IF CHECK BOX IS SELECTED

Karl Heinz Kremer · Accepted Answer

Let's assume you have your fields named "Line1.chk", "Line1.item", "Line1.value", "Line2.chk" and so on, you can use something like this as the custom calculation script for your "Total" field:

var sum = 0;
for (var i=1; i<=7; i++) {
    if (this.getField("Line" + i + ".chk").value != "Off") {
        sum += Number(this.getField("Line" + i + ".value").value);
    }
}
event.value = sum;

Make sure that you change the number of rows in your form in line #3 in the script (currently set to 7, based on the image you provided).

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