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

linking excel spreadsheet to interactive form fields

Forum Index > JavaScript > linking excel spreadsheet to interactive form fields
2007-11-19 16:03:00
nmartin
Registered: Nov 19 2007
Posts: 2

Is it possible to auto populate fields in your document from an exsiting excel spreadsheet and also is it possible to therefore update information on that same excel spreadsheet based off of the answers generated in an interactive field? Basically can you take a spreadsheet and create an interactive from to send out via email which auto populates the fields we already "know" from the excel doc and therefore once the empty fields are filled in can you then export them back into the original excel doc to complete the spreadsheet?

My Product Information:
Acrobat Pro 8, Windows
Top
2007-11-30 06:44:43
#1
lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
Hi nmartin,

This capabilty exists in Acrobat 8 Pro. when using the "Distribute Form" and "Compile Returned Forms" functions.
Check out Ted Padova's article on this at:
[url=http://www.acrobatusers.com/articles/2006/10/extended_forms_features/index.php]http://www.acrobatusers.com/articles/2006/10/extended_forms_features/index.php[/url]

Hope this helps,
Lori

Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.

Top
2008-02-01 17:00:05
#2
scho79
Registered: Feb 1 2008
Posts: 1
Hi,
To move a step further...

I've created a PDF form with some fields already populated from an XML source. I've distributed these forms and received them via email. I've compiled these forms into a single dataset where I can see all the fields on the form. But when I try to EXPORT this data to a CSV file only those fields from the XML source appear in the spreadsheet and none of the other fields that were filled out... What am I doing something wrong?

Any help would be greatly appreciated...
Top