Custom Calculation Script

Question

I'm having a difficult time figuring out a formula for my pdf. There are two different ones that I need.

1. If "Field A" is 1 then take it times $X.XX if "Field A" is > 1 then take it times $XX.XX

2. If "Field B" is 1 then take it times $price1; if "Field B" is 2 then take it times $price2; if "Field B" is 3 or greater then take it times $price3

Thanks for your help!

try67 · Accepted Answer

This formula is in the "Total Field" at the end of the row. So the first row has a "Field A" where the customer puts in the quantity of product they want. If that number is 1 then "Field A" times $price1 and the answer is displayed in "Total Field A" at the end of the row. If the number entered in "Field A" is 2 or higher, then "Field A" times $price2 and that answer is displayed in "Total Field A" at the end of the row.

Same way with the "Field B" row. There is a "Total Field B" at the end of that row. The formula is in that box and calculates depending on what number is entered into "Field B" box.

OK, that's very simple. Use something like this code as the custom calculation for "Total Field A":

var price1 = 10;
var price2 = 20;
var qty = Number(this.getField("Field A").valueAsString);
if (qty==0) event.value = 0;
else if (qty==1) event.value = price1;
else event.value = price2 * qty;

You can adjust that code for the B fields, too.

try67 · Answer

What do you mean by "take it", exactly? Are you talking about changing the same field's value (A or B), or another field?

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