Help with Calculations for PDF Form

[Sarah35648854v387]

I need help forming a proper formula/calculation for a quote form. I've attached a screenshot of the file. I need QTY * 27500 - DISCOUNT = Total.

I've been reading the forums and trying to make a code work, but I'm totally new to this side of Adobe. I need to be able to replicate a similar result for the other remaining rows too. Any idea of how to do this?

Also, adding a total for the TOTAL column would be awesome, but mainly need the above.

Thank you from a form creating noob 🙂

I need help forming a proper formula/calculation for a quote form. I've attached a screenshot of the file. I need QTY * 27500 - DISCOUNT = Total.

I've been reading the forums and trying to make a code work, but I'm totally new to this side of Adobe. I need to be able to replicate a similar result for the other remaining rows too. Any idea of how to do this?

Also, adding a total for the TOTAL column would be awesome, but mainly need the above.

Thank you from a form creating noob.

[Amal.]

Hi @Sarah35648854v387 

Hope you are doing well and thanks for reaching out.

The workflow you are trying to achieve is might be possible using JavaScript. For more information please check the help pages listed below:
https://acrobatusers.com/tutorials/javascript_console/
https://helpx.adobe.com/acrobat/using/applying-actions-scripts-pdfs.html

Hope it will help

Regards
Amal

[Nesa Nurani]

Enter like that as Simplified field notation:

QTY1*27500-DISCOUNT1

[Sarah35648854v387]

Hi and thank you for your response. For some reason it's not working on my end. I've added a screenshot if it helps, but it may not be doable without JavaScript, which is something I am not prepared to handle at the moment. Either way, I appreciate your time!

[Nesa Nurani · Accepted solution]

If you have space in your field names, escape it with backslash like this:

QTY\ 1*27500-DISCOUNT\ 1

[Sarah35648854v387]

OMG! You are amazing!! It works! Thank you! Thank you!