Result field is always filling minimum value even if source field is empty

​Hi @MaxRosenthal ,

Hope you're doing well, and thanks for reaching out.

This isn't an Acrobat bug, it's how JavaScript compares an empty string to a number.

Here's what's happening: when EVPI is empty, this.getField(...).value returns the empty string "", not null or 0. Your very first check is:

if (EVPI <= 5000) {

JavaScript coerces "" to 0 for this kind of numeric comparison, so "" <= 5000 evaluates to true. That means an empty source field always falls into your first branch, Fee becomes 0.05 * 0 = 0, and since 0 <= FM (100), event.value gets set to 100, your minimum. Your later check for EVPI === "" never actually runs, because the first if already caught it.

The fix is to test for the empty case before you do any numeric comparisons at all

Moving the EVPI === "" check to the top means it short-circuits before the empty string ever gets treated as a number.

One side note, not the cause of this bug but worth knowing: event.rc is meant for Validate events (it tells Acrobat whether to accept or reject the entered value), not Calculate events where you're setting event.value. If this script is sitting in the field's Calculate tab, that event.rc = true line doesn't do anything useful there.

Something like:

var EVPI = this.getField("ESTIMATED VALUE OF PUBLIC IMPROVEMENTS").value;

if (EVPI === "") {
    event.value = "";
} else if (EVPI <= 5000) {
    var Fee = 0.05 EVPI;
    var FM = 100;
    if (Fee <= FM) {
        event.value = FM;
    } else {
        event.value = Fee;
    }
} else if (EVPI > 5000 && EVPI <= 25000) {
    event.value = 250 + 0.04 (EVPI - 5000);
} else if (EVPI > 25000 && EVPI <= 100000) {
    event.value = 1050 + 0.03 (EVPI - 25000);
} else if (EVPI > 100000) {
    event.value = 3300 + 0.02 (EVPI - 100000);
} else {
    event.value = "";
}

Note: I'm not a JavaScript developer, the explanation and fix are based on my research into how Acrobat's form scripting handles this, not hands-on coding experience. Worth testing carefully before relying on it in a live form.  

Hope this will work.

~Amal