Suppose your organization asks employees to fill out a travel request Form before they go on business trips. Also, the Travel Department needs to process requests and compiles yearly statistics on travel needs at your organization.

To set up a travel request Form:

  1. Create a Form Template that contains the text, fields, and buttons that you want to appear on the travel request Form.

  2. Associate the template with an SQL database table named TravelProfile by clicking the Form Template's Functions icon and selecting Manage Relational Table. Specify the following settings:

    • In the SQL Table Name box, type TravelProfile.

    • In the Create SQL Table list, click Create database table using name above.

    For more information about defining a Form Template, see Defining a Form Template.

  3. Add a Form by selecting the Form Template:

    • In the Revision Mechanism list, click Content Server Versions.

    • In the Submission Mechanism list, click SQL Table.

    For more information about defining Forms, see Defining a Form.

Using the Travel Request Example

Assume that your travel preferences evolve and update the travel request Form. Each time you open the Form, it displays the previously saved values. You can view the travel profile history by accessing earlier Versions of the Form. For more information about accessing Form Versions, see Working with Forms.

Content Server stores the submitted data in a separate table in the Content Server database. The Travel Department can access the data through an external applications to process the travel requests. Also, they can use LiveReports to compile the yearly travel needs statistics.

For information related to this procedure, see Revision and Submission Mechanism Examples.