Multiplying two form fields in Acrobat
Problem
If you have a total hours field that you want to multiply this by $120.00 to come up with a total due - how can you do this in Adobe 9.0 Pro form?
Solution
You can use the built-in functions in AcroForms to multiply the two fields together.
Detailed explanation
Step 1
When you right click on a form object you can select 'Properties' from the alternative menu. This provides you with several options for the layout, appearance and interactive aspects of the object.
Go to the Calculate tab and you will see that you have four options:
- Value is not calculated (not what we want here)
- Simplified/assisted method for specifying the calculation (easiest way for simple calculations)
- Simplified field notation
- Custom JavaScript calculation script
See screenshot here: http://www.assuredynamics.com/wp-content/uploads/2010/12/Acrobat-field-properties-dialog.png
Step 2
When you select the assisted mode, you can select from the dropdown that you want to multiple the fields. Then click on the "Pick..." button. This will open a dialog where you can select the fields that you want to multiple together. In this case "HoursTotal" and "RatePerHour".
See screenshot here: http://www.assuredynamics.com/wp-content/uploads/2010/12/Acrobat-picking-fields-for-calculation.png
Click OK and thats it!!!
There is a sample here: http://www.assuredynamics.com/wp-content/uploads/2010/12/Assure-Dynamics-Cost-calculation.pdf
Good luck,
Niall
+
This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License. Permissions beyond the scope of this license, pertaining to the examples of code included within this work are available at Adobe.
