Skip to main content
Participant
Feb 20, 2018 12:06 AM UTC
Answered

The value entered does not match the format of the field; java script

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

This topic is closed to new replies. Start a new post to keep the conversation going.
George_JohnsonCorrect answer
Inspiring
Feb 20, 2018 12:39 AM UTC

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.

3 replies

Thom Parker
Community Expert
Community Expert
Oct 20, 2020 6:57 PM UTC

Here's an article that covers this exact topic:

https://www.pdfscripting.com/public/Value-Entered-Does-Not-Match-Format.cfm?sd=40

 

Translate
Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
George_JohnsonCorrect answer
Inspiring
Feb 20, 2018 12:39 AM UTC

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.

Translate
Participant
Feb 20, 2018 5:39 PM UTC

Thank you, George...worked like a charm!

Translate