Custom Calculation Script for PDF Form

Question

Hello,I have no javascript experience at all; however, I learned by searching on the internet that I need to create a Custom Calculation Script on my .pdf form to get it to do what I want. I researched and attempted it myself and was unsuccessful.I have four fields created that are named:NumofCriteriaMetTotalNumofCriteriaPercentofCriteriaMetCPRatingScoreCurrently, I have a simplified field notation (division) in the PercentofCriteriaMet as follows: NumofCriteriaMet/TotalNumofCriteriaand it is working.What I am trying to do is take the number auto-populated from PercentofCriteriaMet and assign a value based on the range below and have the value auto-populated in CPRatingScore0.0 to 0.59 = 00.60 - 0.89 = 10.90 - 1.00 = 2Also, I don't know if it makes a difference, but I currently have the PercentofCriteriaMet and CPRatingScore field set to "read only"If anyone can assist in helping me create a working Custom calculation script, it would be much appreciated.Shelly

try67 · Accepted Answer

As the custom calculation script of CPRatingScore enter this code:

var percCriteriaMet = Number(this.getField("PercentofCriteriaMet").value);
if (percCriteriaMet>=0 && percCriteriaMet<=0.59) event.value = 0;
else if (percCriteriaMet<=0.89) event.value = 1;
else if (percCriteriaMet<=1) event.value = 2;
else event.value = "";

It doesn't matter that the fields are read-only. However, what does matter is the calculation order. You need to make set it so that CPRatingScore is calculated after PercentofCriteriaMet.

Also, you might have problems with the calculation you created for PercentofCriteriaMet. When the divisor field (TotalNumofCriteria) is empty or equals zero that will cause an error, as division by zero is not allowed. To avoid that you would need to use a custom calculation script that only applies the formula if the divisor is not zero. That code could look something like this:

var v1 = Number(this.getField("NumofCriteriaMet").value);
var v2 = Number(this.getField("TotalNumofCriteria").value);
if (v2==0) event.value = "";
else event.value = v1/v2;

brient19211850 · Answer

Hey everyone, I don't write scripts in a PDF docs, however, I need a quick solution for a document I have.

As it is layed out of the PDF document

box 1a box 1b box 2a box 2b box 3a box3b 4c

($amount * # of days) + ($amount * # of days) + ($amount * # of days) = total cost

Thanks

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