Script for calculating Quantity Discounts based on quantity of products

Question

I have created an order form for our products and got through most of the calculations but I am not quite smart enough to get my last one.

The way my form is setup I have products priced each and multiplied by quantity per line.

I need a discount script based on the Quantity so our prices are full price 1-20, $5 off each 21-50, $10 off each 51-100, $15 off each 100+

Is there a simple solution to make this happen?

Thanks in advance for any help you can offer.

bryans16389082 · Accepted Answer

Still not quite what I am looking for so I have multiple products in a drop menu and they are all various prices they calculate with the quantity to get the line total so when you use the QTY*Total this does not work to get the correct discount I want the discount only based on the quantity and when there is 20 I want them all regular price once they hit 21 I want a $5 discount for all 21+ Same With 51 I want all 51+ to have a $10 discount..? etc

Got it now this is the code that worked for my purpose Quantity only discounts.

var qty = Number(this.getField("Quantity").valueAsString);
var total = 0;
if(qty>100)
total = qty*(-15);
else if(qty>50)
total = qty*(-10);
else if(qty>20)
total = qty*(-5);
event.value = total;

Thanks for the help!

try67 · Answer

You can use something like this to achieve it:

var qty = Number(this.getField("Qty1").valueAsString);
var price = Number(this.getField("Price1").valueAsString);
var total = qty*price;
var discount = 0;
while (qty>100) {discount+=15; qty--};
while (qty>50) {discount+=10; qty--};
while (qty>20) {discount+=5; qty--};
event.value = total-discount;

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