How to set maximum on added check box values?

Question

Need help please...
I have 4 check boxes with values of 0,1,5,5 when I calculate and use 'maximum' it works, since I need to get "5" maximum score.
However, on another section, I have 5 check boxes with values of 0,1,1,1,1 where I can't use 'maximum', since I need to get "3" max score. I also can't use 'sum(+)', as it will exceed "3" max when four boxes with values of "1" are selected.

try67 · Accepted Answer

agreed, the approach just happen to work given the circumstances. will not work anymore if values of boxes are limited to lower than "5".
I named section 3 fields as RF3-1, RF3-2, RF3-3, RF3-4, RF3-5 with values of 0,1,1,1,1 respectively.

OK, then you can use something like this as the field's custom calculation script:

var fields = ["RF3-1", "RF3-2", "RF3-3", "RF3-4", "RF3-5"];
var maxValue = 3;
var total = 0;
for (var i in fields) {
	var v = this.getField(fields[i]).valueAsString;
	if (v!="Off")
		total+=Number(v);
}
event.value = Math.min(total, maxValue);

If you need to use it multiple times I would recommend putting the code in a doc-level function, passing to it the fields array and the max value as parameters.

Edited: Sorry, it should be Math.min, not Math.max in the last line of code... Fixed it now.

PDF Automation Station · Answer

The simplest way to do this to create the first check box in the section (in this example, call it "SEC3"). Then in form editing mode, right-click and select "Create multiple copies" and select 1 across and 5 down. The field names will then be SEC3.0, SEC3.1 through SEC3.4. Add the export values. In the text field, calculation tab, select "Value is the maximum of the following fields" and only select "SEC3":

You can do the same thing for the subtotal fields. Make 1 and call it Subtotal, right click >create multiple copies, then in the grand total field select "Value is the sum of the following fields": 'Subtotal'.

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