These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Collect data from several forms and create report

Forum Index > Forms: Acrobat > Collect data from several forms and create report
2009-06-08 06:44:38
zeeshanhashmi
Registered: Jan 2 2008
Posts: 58
Answered

Hi

I have a PDF form that will be emailed to be filled to about 100-200 people. When we get the form back, we want to collect that data from each form and generate an spread sheet for easy evaluation of the data collection.

Please guide me how we can collect the data from, and can transform to a spread sheet ?

thanks
JJ

Top
2009-06-08 07:49:45
#1
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4308
Have you looked at Ted Padova's blog entry [url=http://www.acrobatusers.com/articles/2006/10/extended_forms_features#]Extended Forms Features[/url]?

Under the "Forms" menu option there are the "Compile Returned Forms" and "Merge Form Data => Merge Data Files into Spreadsheet".

George Kaiser

Top
2009-06-08 08:10:28
#2
zeeshanhashmi
Registered: Jan 2 2008
Posts: 58
Wow, Sir !

You are always very very helpful ! I cant express my respect for you in words !

Actually i will not use the Acrobat's distribute option to send the form. Now it will be online so that people will download and then email back to us. Now how would you suggest to collect the forms and generate a spread sheet ???


Because lets suppose that the file name is "blah blah form.pdf" and 140 people downloaded that and returned that after filling their details. So how to manage the same file name for 140 people ?
Top
2009-06-08 09:59:04
#3
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4308
You can either rename the returned files an put them in a folder or you can create a different folder for each returned form.

George Kaiser

Top
2009-06-08 10:01:34
#4
zeeshanhashmi
Registered: Jan 2 2008
Posts: 58
okay thanks a lot.

Is there a way we can automate that ? like when the person filled a form and submit the email button, the pdf attachment gets his name from the name field and append that to the original file name ? can this be done ?>
Top