Compare a sum field against an entered field and add color if not equal

Question

I have a form that a user enters an amount to be funded, then enters individual amounts of fundings and fees that it must equal. If the sum of the individual funds and fees does not equal the amount to be funded, I'd like to show the amount to be funded box in red to bring it to their attention.

I created a hidden field that sums the individual funds and fees ("TotalFundings").

The field the user enters the amount to be funded is ("AmountFunded")

I have a custom calculation in the ("AmountFunded") as follows:

var fund = this.getField("AmountFunded").value;
var total = this.getField("TotalFundings").value;{

if(fund == total)
event.target.fillColor = color.white;
else if (fund != total)
event.target.fillColor = color.red;
}

The only time the "AmountFunded" field is red is only when I click in the box. I'd like it to be red the entire time as amounts are entered and change to white when the amounts equal.

PDF Automation Station · Accepted Answer

When call the field in a custom calculation script that is the field where the calculation resides, use event, not this.getField("fieldName"). Also you don't need else if only else because the result is one or the other (no third option). While your script worked for as written, I would write it like this:

var fund = event.value;
var total = this.getField("TotalFundings").value;

if(fund == total)
   event.target.fillColor = color.white;
else event.target.fillColor = color.red;

If it's not working, check the calculation order and make sure TotalFundings is calculated before AmountFunded.

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