Skip to main content
S
Sarah35648854v387
Participant
March 12, 2024
Answered

Help with Calculations for PDF Form

  • March 12, 2024
  • 2 replies
  • 1585 views

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.

 

    This topic has been closed for replies.
    Correct answer Nesa Nurani

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

    QTY\ 1*27500-DISCOUNT\ 1

    2 replies

    Nesa Nurani
    Community Expert
    Nesa NuraniCommunity Expert
    Community Expert
    March 12, 2024

    Enter like that as Simplified field notation:

    QTY1*27500-DISCOUNT1

    S
    Sarah35648854v387Author
    Participant
    March 12, 2024

    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
    Community Expert
    Nesa NuraniCommunity ExpertCorrect answer
    Community Expert
    March 12, 2024

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

    QTY\ 1*27500-DISCOUNT\ 1

      Amal.
      Community Manager
      Amal.Community Manager
      Community Manager
      March 12, 2024

      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

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices