Form Data to a Delimited File

This is not quite as easy as the email form, but we've created a script that will allow you to send the information entered in a form to a delimited file. This is valuable if you might want to use this data in Excel or a database, since it will create a file that can be imported into those applications.

1. Create your form.
   
   
2. Add a hidden field called ResultFile, with it's value as the location and name of the file you would like the results written to. You will need to contact me at webmaster@juniata.edu for help determining this location. For example:
   
   <input type="hidden" name="ResultFile" value="/Volumes/FilesVolume/web/services/webdev/examples/delimit.xls">
   
   
3. Add a hidden field called ReturnTo with it's value set to the location you would like the user to go after submitting the form. For example:
   
   <input type="hidden" name="ReturnTo" value="http://services.juniata.edu/webdev/resources.html">
   
   
4. Set the action to "http://services.juniata.edu/webdev/delimit.html" in your form tag. For example:
   
   <form name="form1" method="post" action="http://services.juniata.edu/webdev/delimit.html">
   
   
5. Test it out.

An example of a form created for this process can be accessed here. The process will create a file which can be opened with Excel. Each time someone submits info to the form, this file will be updated. Click here to view the file created by the example form.

Return to the Resources page.