How to Automatically Calculate 7% Sales Tax in an Acrobat PDF Form
Question details
The user needs to automatically calculate a 7% sales tax based on the amount entered in one PDF text field and display the result in another field.
- Product
- Adobe Acrobat PDF
- Device & OS
- not provided
- Scenario
- Setting up a fillable PDF form that requires automatic mathematical calculations for a subtotal, sales tax, and grand total.
- Observed behavior
- The user is looking for the correct formula, simplified field notation, or JavaScript snippet to automate the multiplication of a specific field's value by 0.07.
Ensure you know the exact names of the form fields you are working with (e.g., 'Text25' for the subtotal). You will need to access the 'Prepare Form' mode to view and edit these field properties.
Use Simplified Field Notation for Automatic Calculation
The easiest way to calculate a percentage like a 7% sales tax is to use the built-in simplified field notation feature in the PDF form field properties.
Simplified field notation allows you to write basic mathematical formulas using the exact names of your form fields without needing to know complex JavaScript. This method is highly recommended for standard addition, subtraction, multiplication, and division.
Open your document in Adobe Acrobat, navigate to 'Tools', and select 'Prepare Form' to reveal all form fields.
Right-click the field where the sales tax should appear (e.g., Text47) and choose 'Properties' from the context menu.
Go to the 'Calculate' tab in the Properties window, select the 'Value is the' radio button, choose 'Simplified field notation' from the dropdown, and click the 'Edit' button.
Type 'Text25 * 0.07' in the box (replace 'Text25' with the exact name of your subtotal field) and click 'OK'.
To include this newly calculated tax in the final invoice amount, open the properties of your Grand Total field and add the tax field name to its calculation.
Create and Edit Fillable PDF Forms Easily with WPS Office
WPS Office provides a comprehensive PDF editor that allows you to create interactive, fillable PDF forms with text fields, checkboxes, and calculation properties. You can easily manage form layouts and mathematical calculations with a highly intuitive interface.
- 1. Open PDF in WPS Office: Launch WPS Office and open your PDF document, then navigate to the 'Form' tab on the top ribbon.
- 2. Insert Form Fields: Click 'Text Field' to insert new fields for your subtotal, tax, and total amounts directly onto the page.
- 3. Access Field Properties: Double-click the newly created tax field to open its detailed properties window.
- 4. Configure Calculation: Navigate to the Calculate section within the properties to set up your multiplication formula (e.g., Subtotal * 0.07).
Frequently Asked Questions
How do I find the exact name of a form field in a PDF?
Enter the 'Prepare Form' mode in your PDF editor. Double-click the field or right-click and select Properties; the exact, case-sensitive name will be displayed at the top of the General tab.
Why is my PDF form calculation not updating automatically?
This usually happens if the field calculation order is incorrect. Ensure that the subtotal field is calculated before the tax field, and the tax field before the grand total. You can adjust the calculation order in the advanced form editing menu.
Can I use custom JavaScript instead of simplified field notation for calculating tax?
Yes. In the field's Calculate tab, you can select 'Custom calculation script' and click 'Edit'. You would enter a script like: event.value = this.getField('Text25').value * 0.07;
