Send this page





OCTOBER 2006

Extended Forms Features

by Ted Padova

  
0 Votes

In my last article, I talked about enabling PDF documents for Adobe Reader users for form data saving and digital signatures. In this article I’m going to discuss four new features that also rank high on my top ten list of Acrobat 8 features: Running form field recognition, flattening form fields, distributing and compiling forms, and aggregating data. I’ve put all four features into a category I’m calling Extended Forms Features.

Run Form Field Recognition

The first of my favorite new features for forms authors is the new menu command in Acrobat 8 that lets you turn a document created from almost any program export to PDF into a fillable form. Like enabling PDFs for Adobe Reader users, it’s just a matter of selecting a menu command and Acrobat 8 Professional magically creates form fields on the fly.

Open a PDF converted from any Microsoft Office, Adobe InDesign, or Adobe Illustrator document, a text file, or any other file that clearly displays form fields. These field indicators may be boxes, lines, or similar graphic objects that make the document look like a form. Select Forms > Run Form Field Recognition and Acrobat automatically creates form fields for you. It’s not perfect and sometimes it may miss a few fields (for example, the state fields and checkboxes in Figure 1); however, Acrobat does a pretty good job. It sure beats having to create the form from scratch.

Figure 1

What about scanned forms and Adobe Photoshop files? Acrobat says “sure.” Just use the Recognize Text Using OCR to convert a TIFF or other image format opened in Acrobat and then run the form field recognition command. You can populate just about any kind of PDF document with form fields as long as the appearance of the document looks like a form.

Flattening Form Fields

This feature may not rank very high on many people’s lists of favorite new features, but my pals Leonard Rosenthol and Duff Johnson (both of whom host blogs on Acrobatusers.com) are pleased to know I won’t be telling people to refry PDFs anymore at conferences.

Form fields add a lot of overhead to your PDFs and when you need to host files on the web or exchange files via email, you want to trim the file sizes as much as possible. When a form no longer needs fields and you want to distribute information contained in the data fields, you can delete all the fields while stamping down the data on a form.

To eliminate the fields and keep the data, open the PDF Optimizer. Click Discard Objects in the left pane and check the box for Flatten Form Fields as shown in Figure 2. When you save the document from the PDF Optimizer, your data stays while the fields are tossed. This significantly reduces the file size.

Figure 2

Distribute Form and Compile Returned Forms

The new Distribute Form menu command is also found in the Forms menu. This command lets you send a PDF form to a number of recipients, so they can complete the form and send it back to you. When you select Forms > Distribute Form a wizard window opens that walks you through the distribution process. This wizard is similar to setting up a comment review. When the form is distributed, it is also enabled with Reader usage rights so Adobe Reader users can participate in the form completion as well.

What’s neat about the forms you distribute is not the mechanism for distributing the form, but the way you can collect the data. Recipients return a form to you populated with data via an email attachment. Just like working in a comment review, you double click the file attachment, identify the data set you created when you distributed the form, and the recipient form is added to the data set in the form of a PDF Package. As more recipients return forms, the PDF Package is appended to add the additional forms as shown in Figure 3.

Figure 3
Zoom imageSee larger image

The Forms > Compile Returned Forms command is like an extension of the Distribute Forms command. When forms are returned to you via email, you double click the email file attachment and the form is appended to your data set. If you acquire a form from a network server, from a Flash drive or other external media, then you need a way to add the form to your PDF Package. Compile Returned Forms does just that. Select the menu command and the Compile Data dialog box opens. You click a Browse button to find your data set and click the Add File button to add additional files to the PDF Package.

Aggregating Data

From the PDF Package you can export data from multiple forms into a single Microsoft Excel worksheet. Notice in Figure 3 the Export Data button at the top of the list of files in the PDF Package. Click Export Data and a dialog box opens permitting you to save the forms data. From the Save as type (Windows) or Format (Macintosh) pull-down menu you can choose to save the data as CSV or XML. Select CSV and you can open the file directly in Microsoft Excel. When you open the file in Excel, each form will appear as a separate record with all fields shown in a row according to the respective record.

PDF Packages is certainly an exciting new feature and ranks high up on my top ten list of Acrobat 8 features. But we’ve only scratched the surface in this article. Come back next week when I talk about my 6th and 7th top rated features in Acrobat 8: Combining Files and creating PDF Packages.

Article Feedback

Share your thoughts. Tell us what you think about this article.

OCTOBER 25, 2006
hi ted i am working on adobe pro 7 and what you are saying looks like what i have spent the last 3 days trying to find. i want to be able to suck names and id details from an xml file into 300 different forms to distribute to students by email, and then collate their completed forms back into a spreadsheet or database. your article implies some of this is possible in version 8. is the rest of what i want to do possible in 7 or 8? lisa
— lc413

OCTOBER 25, 2006
hi lisa, in acrobat 8 you can distribute a form to 300 users. when you click the distribute button on the new forms toolbar the distribute form wizard walks you through creating a data file and enabling the form with adobe reader usage rights and adding recipient addresses. as your students email the completed form back to you, you just click the form attachment on the email and the student forms are added to your dataset as a pdf package. after all forms are recieved and combined together in a pdf package, you click the export data button that appears in acrobat and the data are exported to a .csv file that you can open in ms excel with all the data aggregated into a single spreadsheet. if you have xml data already collected, you can use the forms > compile data menu command and create the pdf package the same as collecting data from the email attachments. and, oif course, export the data to a .csv file. i believe that acrobat 8 will handle your job very easily. these features are among many great new additions to acrobat. ted
— tedpadova

OCTOBER 26, 2006
thanks ted, this looks like just what we are after. any idea where i can find out a release date for this? lisa
— lc413

OCTOBER 26, 2006
lisa, you know as much about the release date as i do. adobe hasn't made a public announcement for the precise date of the release, but a public announcement was made to the effect of acrobat 8 being released by the end of the 4th quarter. adobe's 4th quarter ends in november, hence we should see acrobat 8 ship by the end of next month (november). keep in touch with acrobat users. as soon as we are made aware of a publc announcement from adobe, you'll see comments from the bloggers here on this site. ted
— tedpadova

NOVEMBER 17, 2006
hi ted, i am working with adobe acrobat forms for some time and in adobe reader 8.0 prerelease i just saw that javascript is throwing an excpetion during the execution. i feels this is some security feature which adobe introduces from 8.0 version onwards. i just read your article about "more enabling features for adobe reader", which metion about 'enable usage rights in adobe reader' feature in adobe acrobat professional. is there any way for me to automate the exiting forms to work in adobe reader- thru adobe acrobat plug-in or ole. i am not looking the adobe livecycle reader extensions server solutions. any idea would be appreciated.
— acrouser

NOVEMBER 19, 2006
as far as i know, you can't execute a javascript to enable pdf forms therefore creating a batch sequence won't work. the only way i know that you can automate the task is to use a server product. ted
— tedpadova

JANUARY 05, 2007
hi ted, i now have my copy of adobe acrobat prof 8 and have managed to accomplish most of what we need, with one exception. i want to send partially completed forms to 300 users. the information for the forms will come from a database or spreadsheet and will be unique information for each separate form that is emailed out. is this possible? thanks, lisa
— lc413

JANUARY 14, 2007
lisa, when working with data connectiuons, your best bet is using adobe livecycle designer. look over the help documents installed with a windows installation of acrobat and the designer information on adobe's web site. ted
— tedpadova

FEBRUARY 06, 2007
thank you very much, this is exactly the information i was looking for, it's amazing how the data can be retrieved with this feature, until today it was a cumbersome task.
— Flofies

MARCH 27, 2007
not a comment, but a quick question....has the author given any thought to the possibility the information captured by the form and being emailed might be confidential or sensitive. would you actually want that information to be emailed. if not that, then is there a way to 'encrypt' the data fields having a confidential or sensitive status to preclude the information's viewing by unauthorized eyes?
— t_venet

MARCH 27, 2007
this article deals exclusively with creating pdf forms and collecting data. we've been able to create forms in acrobat since version 3.2 - albeit through other editing options. the same methods for securing files are available to forms designers as we've had available since acrobat 5. nothing new here related to populating a form and emailing forms to other users. if the pdf author wants to restrict recipients from changing form data or even extracting it, those restrictions can be added by the pdf author.
— tedpadova

MARCH 28, 2007
hi! i've just spent about a day getting returned forms into the dataset. now i'd like to email the whole dataset to a colleague who also has adobe 8 pro. how do i do that? joan
— Joan

MARCH 28, 2007
hi joan. the dataset is a pdf package stored on your hard drive (or server). just attach the file to am email message or host the file online for others to acquire.
— tedpadova

MARCH 28, 2007
thanks ted. i was trying to do it by opening the dataset and then clicking on "attach to email." i tried it your way, which would have worked except the file is too big! thanks anyway
— Joan

MAY 13, 2007
not a comment, but a question. i am a beginner, using acrobat 8 pro. i have a link to a pdf form on a web site, where users can open and fill out the form, and then click submit, which sends their filled in form to me, via email. how can i pull the data from these forms when i get them back and open them? i know that using the distribute forms method creates a data set file, which makes it easy to 'dump' data into an excel spreadsheet, but how can i do this when the file is a link on a web page, and a data set file has not been created, because i am not using the distribute forms feature here? thanks much. vickianny
— vickimac

MAY 17, 2007
i'm new to this form thing. see i'm trying to make my co. use this exciting feature. i sent out the form to my bosses for a weekly updates on design jobs i need them to fill up or correct them if needed. i then distribute it but when they changes their copies on the first row, it'll replace the data that i've listed earlier it somehow replaces what i've my data. can i just import the data which has changes? i'm sorry if i seems a little confusing. i'm trying my best to explain it. and also is there ways that i can take away the arrows on the drop down list, it's hard to view the text especially when you minimize the document. any suggestions will be appreciated..
— ChrisKalis

JUNE 07, 2007
I am a new user to Acrobat 8 pro. I've created a form for visitors to my agency's website to complete and mail in. However, the form is mailed to an individual who has Acrobat Reader. I'm told the filled-in fields are sent to them, not the complete form. How can we resolve this?
— jodiv

JUNE 07, 2007
Be certain to enable the PDF with usage rights. Use Advance > Enable Usage Rights in Adobe Reader and save the file. The Adobe Reader users can then submit the PDF back to you as well as save the form data after filling in the form. ted
— tedpadova

SEPTEMBER 10, 2007
Ted, I've been following this thread with interest and have one question. If I want to import data from an Excel spreadsheet into several forms on the basis of a record (an excel row) filling in a single form, how does the form know which record to drag in? Is the trigger the first field in the record? Thanks, Jay
— jaydesilva

FEBRUARY 11, 2008
I have problem with the Exporting Form Data command into excel spread sheet. I follow all the steps and when I open the excel file I do not get data. Rather I just get a long string of things that I can not understand. I will appreciate if any one tell me how to export the form data into spread sheet(excel).
— bybacha

FEBRUARY 11, 2008
I have an issue with Distribution Forms command. When I distribute the form, the receiver have the option to use the Distribute Command too. How I can restrict this option to the form receiver. If any would like to comment on this. Thanks.
— bybacha

FEBRUARY 16, 2008
Ted I received your email regarding problem of exporting form data into spread sheet. My problem is not resolved. My problem is same as explained above. I just want to tell you that I am using PC. Thanks.
— bybacha

FEBRUARY 25, 2008
Ted thanks. Your email message instructions to me worked fine. I appreciate your patience. Though I was unable to put my question in proper way. Thanks again Ted
— bybacha

APRIL 25, 2008
I'm struggling to help out a member of my research staff with PDF forms. I sent up an eight-form with lots of fields. It is importing fine into an Acrobat dataset file, but I cannot seem to export it in its entirety. It seems the beginning and ending fields are cut off. I've looked everywhere for a solution to no avail. It seems similar to Bybacha's question. Any help would be greatly appreciated.
— cmfnyc

JUNE 02, 2008
I have created a form, and want to be able to compile the ones that are returned. My only problem is that the attachment being returned is in xml format, and adobe will not recongnize it. It tells me that the file was not properly encoded. I have followed all the steps properly, and can't figure out how to fix the problem. Any help you can give would be greatly appreciated.
— gdunkling

Log in to leave comments


<< Back to Articles main menu.



AcrobatUsers.com  >>  User Groups • News • Events • Articles • Blogs • How To • Resources • Member Log in