• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
24

Help with Calculations for PDF Form

Community Beginner ,
Mar 12, 2024 Mar 12, 2024

Copy link to clipboard

Copied

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.

 

TOPICS
Edit and convert PDFs , PDF , PDF forms

Views

306

Translate

Translate

Report

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

correct answers 1 Correct answer

Community Expert , Mar 12, 2024 Mar 12, 2024

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

QTY\ 1*27500-DISCOUNT\ 1

Votes

Translate

Translate
Adobe Employee ,
Mar 12, 2024 Mar 12, 2024

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 12, 2024 Mar 12, 2024

Copy link to clipboard

Copied

Enter like that as Simplified field notation:

QTY1*27500-DISCOUNT1

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Mar 12, 2024 Mar 12, 2024

Copy link to clipboard

Copied

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!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 12, 2024 Mar 12, 2024

Copy link to clipboard

Copied

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

QTY\ 1*27500-DISCOUNT\ 1

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Mar 12, 2024 Mar 12, 2024

Copy link to clipboard

Copied

LATEST

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

Votes

Translate

Translate

Report

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