### By Scott Trudeau

### Created

November 17, 2008

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 am having the same problem as Jennifer Medich…cannot select more than one field for a calculation. Thanks for the help!

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.