Web developers often use HTML forms to gather information from visitors. For example, web visitors might complete an HTML form in order to request more information about a service, sign up for a newsletter or register for an event. HTML forms once included "mailto" scripts that simply emailed the form submission to a designated email address. However, developers now commonly write scripts to transfer form submission data to dedicated databases in order to protect company email addresses and make the process of retrieving and using form data more efficient. If you use a reporting device like Business Objects, you can easily retrieve your form data from your database in a text file or a variety of other formats.
Create a script that will transfer the data from your form submissions to a dedicated database. Ensure that you correctly map the fields you intend to include on your form (first name, last name, etc.) to columns in your database. Host the script on your web server and make note of the URL, as you will need to include this in the "action" command for your HTML form.
Create an HTML form on your website. Edit your webpage code to include the HTML code for your form in the location that you want the form to appear on the page. Begin your form with the "<form>" tag, and end it with the "</form>" tag. Designate your script name from step 1 as the "action" of your form. Use the "input" command to create an input field for each piece of data that you wish to capture in your HTML form. Create a button to submit your form with an input field that has a type, name and value of "submit."
Check in your updated code to your website. As an example, your basic form code might look like:
<form method="post" action="yourscriptname">
<input type="text" size="10" name="first">
<input type="text" size="10" name="email">
<input type="submit" name="submit" value="submit">
Test your form to ensure that it works as expected. Access your database using a reporting tool like Business Objects. Use Business Objects Desktop Intelligence to create a report that returns the data collected on your form during any time period you specify. Run the report and view the results. Export your data by opening the "Data" menu and selecting "View Data." When the "Data Manager" window appears, click the "Export" button. Choose the text format, such as .CSV or .TXT, that you wish to use for your text file. Give the file a name and save it in a location you will remember.
- Photo Credit submit button image by creative from Fotolia.com
How to Make Your eBay Listings Appear Higher in Best Match Search Results
Best Match is eBay's sorting technology that displays search results based on various factors such as keywords, your listing end time, detailed...
How to Create a Form in Word
When you create an editable form in Microsoft Word you allow users to enter information on the form electronically. A form is...
How to Call an External PHP File Form with HTML
The "action" attribute for the HTML "<form>" tag is used to call an external PHP file. The method attribute of the "<form>"...
How to Update Text in an HTML File
You can make minor or major changes to a Web page within an HTML file. Hypertext markup language (HTML) helps you create...
How to create a blacklist for Google search results?
While Google is a great search engine, it can be frustrating at times when the same unwanted websites keep surfacing to the...
How do I Create Graph Results for Questionnaires?
Compiled data or questionnaire results may be visually graphed to succinctly display the information. This method of results viewing is an effective...
How to Run a Query on an Access Form
Running a query from an Access form is done by assigning the query to a control object on the form. Use this...
How to Create a Microsoft Access Form or Report From Filtered Records
In Microsoft Access, creating a form or report that is based upon filtered records requires an understanding that the table upon which...