Code to check that total does not exceed 100%

Question

I have a form that I need to enter percentages assigned for one to four people, the total cannot exceed 100%. Each field checks the field above it, adds the percentages, and an error message pops up if the total is over 100%.

Example 1:

Person 1 25% [under 100%, proceed to next field]

Person 2 25% [under 100%, proceed to next field]

Person 3 25% [under 100%, proceed to next field]

Person 4 35% [over 100%, error message "Total cannot exceed 100%"]

Example 2:

Person 1 25% [under 100%, proceed to next field]

Person 2 80% [over 100%, error message "Total cannot exceed 100%", stop checking]

Person 3

Person 4

I'm using a MAC but this should work on Windows as well.

Thanks for any help you can give me!

DP

diane_ngf · Accepted Answer

Thanks! We're getting there but I must be doing something else wrong.

I tried the code and if the numbers entered start out under 100 it works, but if any one of the numbers goes over 100 it throws the error even after the number is corrected.

For example, I entered the first value as 125%, got the pop-up, I changed it to 100% and got the pop-up again. After that it let me go to the next field. But when I entered a number in there I got the pop-up again. So it's not clearing the error once I correct the number. Is there a "clear" I can add to the formula?

BTW, I'm using ==> if (event.value) event.value += "%"; in the custom format script to add the % sign.

I read a few posts about entering 50 and seeing 5,000% when formatting it as a percent. So I found the code below that took 50 and made it 50% without having to enter it as .50. For others who need to know this, it's in the Format tab, Custom, Custom Format Script.

if (event.value) event.value += "%";

When I couldn't get your formula to work I changed >1 to >100 and it worked perfectly.

if (event.value>100) app.alert("Error! The sum of the fields must not exceed 100%.");

Thank you for your help! You're a genius

diane_ngf · Answer

I entered the following for Person 1 and it works, but when I try to check Person 2 it doesn't create the pop-up.

Person 1 - THIS WORKS

var v1 = Number(this.getField("Percentage_1").valueAsString);

var v2 = Number(this.getField("Percentage_2").valueAsString);

var v3 = Number(this.getField("Percentage_3").valueAsString);

var v4 = Number(this.getField("Percentage_4").valueAsString);

if(v1>100) {

app.alert("Total cannot exceed 100%");

} else {

event.value = v1;}

Person 2 - THIS DOESN'T WORK

var v1 = Number(this.getField("Percentage_1").valueAsString);

var v2 = Number(this.getField("Percentage_2").valueAsString);

var v3 = Number(this.getField("Percentage_3").valueAsString);

var v4 = Number(this.getField("Percentage_4").valueAsString);

if((sum(v1+v2))>100) {

app.alert("Total cannot exceed 100%");

} else {

event.value = v2;}

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