Copy link to clipboard
Copied
Hello, I am working on an Adobe PDF Form and believe I need a custom script for a calculation table. I have no JavaScript experience at the moment and am hoping someone can help me with a formula so I can complete a project. We have a table in a form that is supposed to calculate a discount. The field for the formula in question is a rebate field with a maximum value of $4,000. The field calculates the # of blocks multiplied by $1,000 with a maximum rebate of $4,000. How do I write a formula that returns the rebate amount if it is less than $4,000 (e.g. $1,000, $2,000 or $3,000) and only displays $4,000 if the rebate amount is equal to or greater than $4,000? I hope this is understandable and please forgive my ignorance. Thanks!
Let's say the other field is called "Rebate". Use this code as the custom calculation script of the Discount field:
event.value = Math.min(4000, Number(this.getField("Rebate").value));
Copy link to clipboard
Copied
Let's say the other field is called "Rebate". Use this code as the custom calculation script of the Discount field:
event.value = Math.min(4000, Number(this.getField("Rebate").value));
Copy link to clipboard
Copied
Thank you - that worked like a charm!
Copy link to clipboard
Copied
Hello Try67, I hope you dont mind me jumping on this thread I have a similar calculation but couldnt quiet work it out from your answer above- I am fairly new to adobe and communities. I have a form where people fill out how much of each product they would like and at the end need to calculate a delivery fee for order under $100 being $10. Order over $100 will get free delivery. Are you able to help or should I post this as a new thread? Thanks heaps Sarah
Copy link to clipboard
Copied
New Thread.