Skip to main content
B
bgb6
Participating Frequently
April 9, 2020
Answered

Field Calculation Javascript

  • April 9, 2020
  • 1 reply
  • 1514 views

Hi, 

I am in need of assistance writing a custom calculation script for a field.

My form includes two fields that include a low and a high value, and another field that has a total value. I need a script to show me the variance if the total value falls outside of the low or high. If the total value falls within the range, it should just say $0.00

 

Example: Range is $2,000.00 to $5,000.00 and the Total is $5,500.00. I need it to return $500.00. 

Can anyone help me with this?

Thank you in advance!

This topic has been closed for replies.
Correct answer Thom Parker

See this article:

https://www.acrobatusers.com/tutorials/conditional-execution/

 

YOu'll need somehting like this in the calculation field for the variance 

 

var total = this.getField("Total").value

if(total < 2000)

     event.value = 2000 - total;

else if (total > 5000)

    event.value = total - 5000;

 

1 reply

Thom Parker
Community Expert
Thom ParkerCommunity ExpertCorrect answer
Community Expert
April 9, 2020

See this article:

https://www.acrobatusers.com/tutorials/conditional-execution/

 

YOu'll need somehting like this in the calculation field for the variance 

 

var total = this.getField("Total").value

if(total < 2000)

     event.value = 2000 - total;

else if (total > 5000)

    event.value = total - 5000;

 

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
B
bgb6Author
Participating Frequently
April 9, 2020

Hi Thom,

Thank you for getting back to me so quickly.

The problem that I have is the Low and High ranges (the 2000 and 5000) are form fields themselves and will vary based on the users entry.

Is the concept similar?

Thom Parker
Community Expert
Thom ParkerCommunity Expert
Community Expert
April 9, 2020

Yes it is, the limit values are acquired and used in exactly the same way as the total

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices