Skip navigation
Currently Being Moderated

Submit FDF Form Data to Web

Mar 26, 2012 11:34 AM

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?

 
Replies
  • George Johnson
    9,208 posts
    Aug 11, 2002
    Currently Being Moderated
    Mar 26, 2012 11:49 AM   in reply to AuntDi3

    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.

     
    |
    Mark as:
  • George Johnson
    9,208 posts
    Aug 11, 2002
    Currently Being Moderated
    Mar 26, 2012 12:50 PM   in reply to AuntDi3

    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.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points