How to Calculate Quantities and Prices in a PDF Form
Question details
The user needs a method to separately calculate the total number of people and the total cost within an interactive PDF form.
- Product
- Adobe Acrobat / PDF Editor
- Device & OS
- not provided
- Scenario
- Creating an interactive PDF form with drop-down lists for adult and child ticket quantities, where total headcount and total revenue need to be calculated simultaneously.
- Observed behavior
- The drop-down export values are currently set to the ticket prices, making it difficult to extract and calculate the total quantity of people separately from the overall cost.
Ensure you have access to a PDF editor with advanced form field capabilities, and verify the exact names of your drop-down and text fields before applying calculation scripts.
Separate Quantities and Prices Using Hidden Fields
By changing the drop-down export values to represent quantities and storing prices in hidden text fields, you can easily calculate both metrics using a simple script.
Binding prices directly to drop-down export values limits your ability to count the actual number of items selected. The best practice in PDF form design is to separate the item count from the item cost.
Open the properties of your adult and child drop-down lists. Navigate to the Options tab and change the export values from the ticket prices to the actual quantities (e.g., 1, 2, 3).
Add a new text field to your form for the price per person. In the field properties under the General tab, change the 'Form Field' visibility setting to 'Hidden' so it does not display to the user.
In the hidden price field's properties, go to the Options tab and enter the price per person in the 'Default Value' box. This guarantees the price remains intact even if the user clears or resets the form.
Create a new text field for the 'Total Cost'. Open its properties, navigate to the Calculate tab, and choose 'Simplified field notation' or 'Custom calculation script'. Write a script to multiply the drop-down field name by the hidden price field name.
Easily Create and Edit Interactive PDF Forms in WPS Office
WPS Office includes a robust PDF editor that allows you to seamlessly insert drop-down lists, manage hidden text fields, and adjust form properties for accurate calculations.
- 1. Open your PDF in WPS Office: Launch WPS Office and open the PDF form you want to modify.
- 2. Navigate to Form tools: Click on the 'Form' tab in the top navigation ribbon to access all interactive form controls.
- 3. Add or modify fields: Select 'Drop-down' or 'Text Field' to add new elements, or double-click an existing field to open its detailed properties panel.
- 4. Configure properties: Use the properties dialog to set export values, adjust visibility to hidden, and apply default values for your calculations.
Frequently Asked Questions
Why is my PDF form calculation cleared when I reset the form?
If your hidden price field relies on a typed value rather than a designated 'Default Value' in its properties, resetting the form will clear its contents, resulting in a calculation of zero. Always input static prices into the Default Value field.
Can I hide a text field so it doesn't print or show on the screen?
Yes. In the form field properties dialog under the General tab, you can change the visibility setting from 'Visible' to 'Hidden' or 'Visible but doesn't print' depending on your needs.
How do I write a basic multiplication script in a PDF form?
In the target total field's properties, go to the Calculate tab, select 'Simplified field notation', and click Edit. Enter a formula like 'QuantityField * PriceField', ensuring you type the exact names of your existing form fields.
Why shouldn't I use the price as the export value in a drop-down?
If you use the price as the export value, you lose the ability to extract the actual quantity selected. This makes it extremely difficult to calculate the total number of attendees or items without building complex, redundant conditional scripts.
