# Formula for multiplcation and conditional limit on Adobe PDF form

New Here ,
Apr 06, 2016 Apr 06, 2016

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!

TOPICS
Acrobat SDK and JavaScript, PDF forms

Views

357

Likes

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Adobe Community Professional , Apr 06, 2016 Apr 06, 2016
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));

Likes

4 Replies 4
Apr 06, 2016 Apr 06, 2016

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));

Likes

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
Apr 06, 2016 Apr 06, 2016

Copied

Thank you - that worked like a charm!

Likes

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
May 19, 2020 May 19, 2020

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

Likes

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
May 20, 2020 May 20, 2020

Copied

LATEST