Saving Form Results
Once you create a form and collect information from visitors on the Web, you can save the form results to a database or file, or send the form results in an e-mail message. You can save the results to an ODBC-compliant database or a text or HTML file. When a site visitor fills out a form and submits it, FrontPage enters the data directly into a database or file, or sends an e-mail message. By default, form results are saved to a text file. The Save Results component (which saves the form results) requires FrontPage Extensions or SharePoint Team Services, both on the Web server you use to develop the site and the one visitors use.
Save Form Results to a File
| Click the View menu, click Page, and then open the Web page you want to use. |
| Right-click the form, and then click Form Properties. |
| Click the Send To option. |
| Click Options. |
| Click the File Results tab. |
| Enter the location and name of a new file, or click Browse, locate and select the file to which you want to save the results, and then click Open. |
| Click the File Format list arrow, and then select a file format (such as HTML or Formatted Text). |
| Click OK. |
| Click OK. |
Save Form Results to a Database
| Click the View menu, click Page, and then open the Web page you want to use. |
| Right-click the form you want to save the results from, and then click Form Properties. |
| Click the Send To Database option. |
| Click Options. |
| Click the Database Connection To Use list arrow, and then select an existing database connection. |
| Click the Table To Hold Form Results list arrow, and then select the table where you want to place the form results data from. |
Click the Saved Fields tab.
The fields in the form are listed. For each field, you must specify the database column in which you want to save the data. | Click the form field you want to modify. |
| Click Modify. |
| Click the Save To Database Column list arrow, select the column where you want to save the form field data, and then click OK. |
| Repeat steps 8 through 10 for each form field, and then click OK. |
| Click OK. |
|