Javascript Help for calculation in a fillable PDF

Forum|Forum|6 years ago
January 10, 2020
2 replies
3229 views

Hi! I am needing some help. I am not Javascript savvy ..
I am creating a fillable PDF in Adobe Acrobat PRO DC. I am needing to calculate one column so that everything in the 15 rows(milage 54milerow1, milage 54milerow2, milage 54milerow3, etc) is multiplied by .54 and then totaled at the bottom in Sum16... Can someone help me with this?

This topic has been closed for replies.

Correct answer try67

You can use this code as the custom calculation script of Sum16:

var total = 0;
for (var i=1; i<=15; i++) total+=Number(this.getField("Milage 54mileRow"+i).valueAsString);
event.value = total * 0.54;

M

minordnsAuthor

Participant

Thank you! Is there anything I need to change/add in this? Or should I be able to just copy and paste? I went into the properties of Sum16, went to calculate and pasted the code under custom calculation script but it's not doing anything.

try67

Community Expert

You don't need to change anything. However, you do need to change the value of one of the fields for it to "kick in".

If it's still not working press Ctrl+J and check if there are any error messages in the window that opens.

M

minordnsAuthor

Participant

This is what I am getting back.

try67

Correct answer

Community Expert

You can use this code as the custom calculation script of Sum16:

var total = 0;
for (var i=1; i<=15; i++) total+=Number(this.getField("Milage 54mileRow"+i).valueAsString);
event.value = total * 0.54;

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