Comments If you haven’t had the opportunity to sign up for a FREE Acrobat.com account I suggest you do so in the near future. You get a handful of some really fantastic tools which include Buzzword, Adobe Connect Now, a PDF tool, and some online storage space. Buzzword is the perfect application for laying out a document that will eventually be turned into a PDF interactive form in Acrobat 9.
Acrobat 9 is Adobe’s newest PDF publication tool and the Adobe “wizards” have made it easier than ever to turn a simple document into an interactive PDF. In this tutorial I’ll demonstrate how to:
- layout a form using Adobe’s free Buzzword service (really cool)
- export the file to PDF
- convert the PDF to a digital form using Acrobat 9′s “Form Field Wizard”
- configure the fields to calculate form data
Scott,
do you know how to calculate using military time in forms.
thanks
how to skip a field that has been calculated automatically?
This is brilliant! Thank you for showing these options, I never knew of them. I’m having a heck of a time trying to subtract. I read about having to use javascript and did the simple Field1 – Field2 and the field names are spelled correct and the spacing is also correct. I still can’t make it work
. If anybody has suggestions, I am open! 
Thank you!
Hi Scott,
Can you tell me what the custom calculation script would be to subtract one time field (HH:MM) from another time field (HH:MM)? I also need to work this form to calculate time for a rolling day. For instance, if I depart someplace at 23:12 & arrive at 02:15 the following day, I need the form to calculate the travel time.
Thanks,
Rob
I would like to have one field equal another multiplied by .555. I am looking at properties and calcs but stuck after that. Can you help?
G’day Scott,
I’m hoping you may have the answer to my search. I am trying to find a way for Adobe PDF to count the number of fields ‘completed’. They are check boxes on a large table and i want to count the completed checked boxes in a row and in a group and then calculate stats from the SUM. I just need to be able to count how many fields in a row have been ckecked.
I can’t find a COUNT function and I thought you may have a way of working that out.
Regards
Rex
Great tutorial. I have managed to get as far as you had in your tutorial except that the formulas did not calculate! Also, my formula is slightly more complex – Qty1 * 2.5+70. In my Excel spreadsheet, I used the IF function so a blank cell will remain that way. I also am looking for a way to take a date in one field, add a number of days and have the result be a date (in this case an expiration). Can that be done?
Many thanks for the great tutorial
I have an Excel form that I use often. I would like to make it a PDF. I did the conversion and all is well with the text fields. The problem is with two sections: a fee calculation which works like this: “X” sqFt * $2.50 plus $70. I have searched and searched to find a formula but the best I can do will actually make the calculation, but leaves $70 in the results field even if the quantity field is blank or zero. The calculation is pretty simple but the “plus $70″ seems to throw it off somehow.
The second problem is that the form is issued with an expiration date. So, we have a date field, a days field and an expiration date field. The permit is issued on a date, for a certain number of days and thus expires on the expiration date. Works fine in Excel but I cannot make it work using Javascript. Can anyone help me?
Adobe wont let me select cells I need calculated. I can select all or non. What am I missing??
I have a master time calendar for our unit. I would like the information entered, along with the formatting, to drop into an employee master calendar. I can’t seem to find out how to do that.