Is it possible to program a form to send certain fields to a spreadsheet housed on a website upon submitting?
I have created a simple spreadsheet with order number, change amount, and customer name. When sales submits this form to the person entering the order, I would like this information to be sent to my spreadsheet. I thought, if I added a submit button to the form and directed the fdf file to this spreadsheet, that would work. However, everytime I try to test it, I get a "general error" and it displays the web address for my spreadsheet. What am I doing wrong, or is there a better way to accomplish this goal?
It won't be as simple as that. You can submit a form to a web server, which could read the data and add it to a spreadsheet, but this would require you to program the web server (e.g., using PHP, Perl, ASP, etc.) to do this. The form would submit to this server-side program (script), as opposed to the file as you're currently attempting to do.
If you use Acrobat to distribute the form and collect the responses in Tracker, it can export the results to a CSV or XML file, which can be placed into a spreadsheet.
Unfortunately, I don't believe my IT department will allow me to do any programming with our web server.
The form is currently set up, so that the salesman just e-mails the entire pdf file to the person entering the orders. I would like to keep that part in tact, and just add some programming or something that will send just the data to either a web page, or even a different mailbox. Is it possible to have the form e-mail the pdf file to one person and a csv file to another person? I just want to get a minimal amount of the data in one location, so that I can easily move it to an Access database.
If the other person has Acrobat, as opposed to just Reader, they will be able to export to CSV, either using the built-in method (e.g., Forms > Manage Form Data > Merge Data File into Spreadsheet) or by some JavaScript programming to create the CSV data file as a data object and exporting it.
North America
Europe, Middle East and Africa
Asia Pacific