Copy link to clipboard
Copied
I created a custom script that equates a percentage and that works fine. However, I get the error message of "the value entered does not match the format of the field". I believe that by other discussions I have read that I need to set a script that ensures the field has a non-zero value but don't know how to write it. My current calculation is: event.value = this.getField("Sponsor Total").value/this.getField("Overall Project Total").value
1 Correct answer
var numerator = +getField("Sponsor Total").value;
var denominator = +getField("Overall Project Total").value;
event.value = denominator !== 0 ? numerator / denominator : "";
That last line translated to English would be: If the denominator is not equal to zero, set this field's value to the numerator divided by the denominator. Otherwise, make it blank.
Copy link to clipboard
Copied
var numerator = +getField("Sponsor Total").value;
var denominator = +getField("Overall Project Total").value;
event.value = denominator !== 0 ? numerator / denominator : "";
That last line translated to English would be: If the denominator is not equal to zero, set this field's value to the numerator divided by the denominator. Otherwise, make it blank.
Copy link to clipboard
Copied
Thank you, George...worked like a charm!
Copy link to clipboard
Copied
Here's an article that covers this exact topic:
https://www.pdfscripting.com/public/Value-Entered-Does-Not-Match-Format.cfm?sd=40
Use the Acrobat JavaScript Reference early and often

