16th July 2007

Forms Data Collection with Acrobat 8 Professional

If you watched the eSeminar last Wednesday (July 11, 2007), you saw me whiz through creating a Form Distribution Work flow from a word document that I recieved from my son’s soccer team. I got a lot of feedback asking for a more indepth look at how to create a forms based workflow in Acrobat 8 Professional (Note: that this is a windows only workflow for now, the workflow for the Mac is slightly different and I will be putting the Mac version up here as soon as my Mac comes in :-). So for all my adoring fans, here you go!


Ok so, as with the eSeminar, I will start in Word with the original document that the team sent out. I mean come on, trying to type in the spaces then backing out to keep the layout correct is just a royal pain. So, if this happens to you, be a hero and follow these steps. I will start by creating a PDF from the Word Doc using the PDF makers.  I can’t stress enough to use the PDF Makers (the little Acrobat Buttons you see in all the office applications. Your resulting PDF will be a much richer and will make this process much easier.

Fig. 1  Using the PDF Makers to create the PDF from Word

Ok now that we have the PDF Created, we still can’t fill in any of the fields.  But, wait, there is a a way, it is called the typewriter tool!

Fig. 2  Our word document as a PDF

Just go to Tools Typewriter Typewriter and you will get a cool little cursor that will allow you to position text on the line or anywhere on a PDF (Fig 3)

Fig. 3 Using the Typewriter tool

which is a really quick way of filling out a form that is a flat document (one with out active fields), but, the person that gets this form will still have to enter the fields into what ever system by hand, and as we all know that is a huge bummer!  In short the data collection is a no go!  So what can we do to this PDF to make it a dynamic xml form?  Well pior to Acrobat 8 you had two choices, first you could just use Acrobat and manually draw fields on the PDF.  This was pretty easy to do, but, is a bit tedious.  Second, you could try to import it into Acrobat Designer and even though much more powerful, not real user friendly.  So what do you do?  Well your a lucky dawg, dawg, (humm, losing some street cred here) you use the new Create New Form in Acrobat 8!  Here how it’s Done.

To start, go to Forms Create New Form, this will start a wizard that will walk you through creating a dynamic form and create a distribution/collection work flow.

Fig. 4 Starting the Form Field Recognition

Now we just answer the questions as needed:

Start with an electronic document, notice that you have a few options here as well, but will be saved for other posts
STEP 1 - In this case we will start with the Current Document
STEP 2 - Now you have an interesting choice, adding fields by hand (booo) or Run Auto Field Detection (this sounds like much more fun!)
STEP 3 - Show you have completed the Auto-Detection, notice that the fields have all been found, your mileage my vary.  One of the tips for a better field detection is to make sure there is a space between the fields, and the explanation text.
STEP 4 - Congratulations!  You got the first part done.  Now the wizard will auto start Adobe LiveCycle Designer this is a step that requires you to create a email button.
STEP 5 - Add the buttons, here I add my email and de-select the Add a print button
STEP 6 - Now in the video you will see an expanded lesson here but for the blog entry just save it off to somewhere you can find it.  Then reopen the PDF in Acrobat.

Now you have a form sitting in Acrobat, we need to send it out so that we can get some data back.  We will now start the Distribution Form workflow.

Start the Distribute Form workflow by going to Forms Distribute Form.

STEP 1 - Set your delivery options; here I am using the simple eMail return, you can secure them on return but we will save that for another post
STEP 2 - Ok this is a very important step here, this is where you are going to tell the system where to put the Data Collection.  This will be a repository for the returned form data.  Make sure you out this in a location that you have access too, and will not change.  If you move it, every time you open an eMail with a return form you will have to manually direct the data to the new location. Again not the end of the world but still a hassle!
STEP 3 - Tell Acrobat who else gets to play.  Here you can either grab people from your Address Book, or type in an eMail, Note the you can type many eMails at once the only thing to know is to make sure to add a return between each address.  Your address book will be automatically linked to Acrobat at install, you do not need to do any thing to your system to get this bonus.
STEP 4 - Tell the receivers what they are doing.  In step 4 you tell the receivers of the form what is the about, you can have a standard boiler plate message body saved as a text file and just link it in at run time. Here I just added the text “Thanks Tim”  at the bottom.

You are now done and a eMail has been placed in your Outbox.  The workflow has began.  The video shows what happens when a user gets the form and fills it in, adds a digital signature, and then saves it (all things new to Acrobat 8 Professional) with the Adobe Free Reader!  What will happen now is as people start to submit the forms back you will start getting eMails with the data, so this is pretty good, but, what can you do with this data, how do you COLLECT this data, what form is it?  Well let Acrobat come to the rescue here, simply open your eMail and double click on the attachment.  Acrobat will load and you will see a new Form but it is a PDF Package, the data you are receiving from the eMails is XML data that is propagating the fields of a PDF Package (pretty darn cool) this allows you to collect, collate, and look at the data. (fig.5)

Fig. 5 - Here the PDF Package give you a great look at your data

But, this view of the data is a bit structured and sometimes you want to do some math on the data or hook it to some other data.  You have the option to export the data to either XML or a CSV file that can be opened by Excel, or almost any database program out there!

Well, that’s it for this one, whew it was a long one, I better go, Brazil and Argentina are about to start the finals of the Copa America, and dude, I can’t miss that!  Be good and remember to put some life in your life!  For a Video of this Blog Click here!

Tim Huff

This entry was posted on Monday, July 16th, 2007 at 10:50 pm and is filed under Support, PDF Creation, General, Forms, Acrobat 3D. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

There are currently 15 responses to “Forms Data Collection with Acrobat 8 Professional”

Why not let us know what you think by adding your own comment! Your opinion is as valid as anyone elses, so come on... let us know what you think.

  1. 1 On July 20th, 2007, George Kaiser said:

    What is wrong with using Acrobat? It has features that LiveCycle Designer does not, like templates to name one.

  2. 2 On July 27th, 2007, Tim Huff said:

    I think Acrobat is the best way to do most of this work, but, I was just showing Designer to give you guys a taste of how to use it. Sorry for any confusion.

    Tim

  3. 3 On August 3rd, 2007, Bill Guy said:

    This will be long and I don’t know if Acobat can do all this?
    I work for a gallery that sends forms to artist that needs to be filled out with Name, address, shipping address (for returning work) many check-marks for agreeing to terms and insurance.

    Our PDF form is three pages long and in the past needed to be printed out. Artists had to hand fill out this form so Acobat does look like our savior but…

    Some type of name or ID for each artist needs to be on each page if it is printed out.

    In the past if a field has the same (Now found under Object/Binding/Name)the info would carry over. If given the same name can this still happen?

    Can a group of check-marks be set up so only one can be checked?

    Is there someone at Adobe we can contact about forms creation when we have these types of questions?

    Tim’s Reply————————————————————————————————————
    Yes all that you are asking for can be done with Acrobat, I will send you some short videos on how this is done.

    Thanks for reading
    Tim

  4. 4 On August 3rd, 2007, Bill Guy said:

    Big thanks Tim, I am looking forward to more information since most of my training with Acrobat is self infected.

  5. 5 On August 15th, 2007, Raymond said:

    Just checking. Everything that you did in the Demo, you did with adobe acrobat professional? No other products are required?
    I am thinking about getting a Fujitsu FI-5110C scanner would that be sufficient to start converting my old paper forms to electronic? One more thing I have old forms that are already filled created with livecycle extensions. Can I make a package of these old forms and extract the data from them?

    Adobe forms raise an interesting question for me how do you decide when to use a form to gather data and when to create a series of web pages that the user fills out and then print out the form for signature?

    Thank you,
    raymond

    Tim’s Response——————————————————-

    Yes it was all done with Acrobat 8 Professional - Windows version, I am in the process of getting a Mac so I can show the differences.

    Thanks for reading and posting

    Tim

  6. 6 On August 21st, 2007, John Swanson said:

    I understand with form data collection, people start to submit the forms back you will start getting eMails with the data, and then you can collect the data. What happens if 90% of the respondents reply and you go through converting the data to an excel file, and then the remainder of your responses come in over time. Each time one comes in do you need to go through the whole process of collecting all the responses and converting the data to csv and then .xls; or is there a process whereby you can add a response to an existing .xls. Thanks.

  7. 7 On August 31st, 2007, Forms from Scratch using Adobe InDesign CS3 and Acrobat 8 Professional » I didn’t know Acrobat could do that! said:

    […] pretty cool huh! To see how to create a workflow for forms data collection see my blog entry Forms Data Collection with Acrobat 8 Professional and it will take you step by step into the world of forms workflows.  Check out the Videos […]

  8. 8 On September 25th, 2007, Cash Advance said:

    Amazing write up on t know Acrobat could do that!! I enjoy your posts.

  9. 9 On October 2nd, 2007, Christine said:

    First off - i love creating forms…love it.
    However - i created forms, distributed them, etc…but when my test audience attempted to respond - they hit the “submit by email” button and my email along with body copy all was automatically pasted into the carbon copy field. Any ideas what is going on? I have tested it multiple times and it continues to happen.
    Thanks
    Christine

  10. 10 On October 17th, 2007, mike kenny said:

    Tim,

    How about the (parent) signature feature. How is this accomplished and what are the latest legal issues for electronic signature (or not having a “wet” signature)

  11. 11 On November 5th, 2007, Heidi said:

    I am trying to create a form for people to fill out on our website and submit via email. There are 10 text boxes for name, address, etc. Under each box is a checkbox for them to check if the person entered in the box above it is the captain of that team. What can I do so that if that checkbox IS checked, that the information in the text box above is required?

  12. 12 On November 16th, 2007, Google said:

    Google…

    Google…

  13. 13 On December 2nd, 2007, Using an Acrobat 8 Form to collect data over the Web » I did not know Acrobat could do that said:

    […] in an Acrobat Package. For a reference see these two blog’s that relate to forms data collect Here and […]

  14. 14 On December 14th, 2007, kristen said:

    I’m working on a calendar that I want to distribute, have individuals in my group complete, return and then it compiles all the information into one form. Is that possible? Advice?

  15. 15 On May 28th, 2008, JLHigginbottom said:

    I do not see a reply to the following post and I have the same question:
    6 On August 21st, 2007, John Swanson said:
    I understand with form data collection, people start to submit the forms back you will start getting eMails with the data, and then you can collect the data. What happens if 90% of the respondents reply and you go through converting the data to an excel file, and then the remainder of your responses come in over time. Each time one comes in do you need to go through the whole process of collecting all the responses and converting the data to csv and then .xls; or is there a process whereby you can add a response to an existing .xls. Thanks.

Leave a Reply