Suppose your organization tracks employees' working hours by means of electronic time cards. Each employee maintains a separate time card.

To set up an electronic time card Form:

  1. For each employee, create a Form Template that contains the text, fields, and buttons that you want to appear on the time card.

  2. Associate each template with an SQL database table named the same as the employee name by clicking the Form Template's Functions icon and selecting Manage Relational Table. Specify the following setting:

    • In the SQL Table Name box, type the table name the same as the employee name.

    • 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. For each employee, add a Form based on the employee's Form Template. When you define the Form, use the following settings:

    • In the Revision Mechanism list, click SQL Table.

    • In the Submission Mechanism list, click <None>.

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

Using the Time Card Example

As two or more employees, record the hours you spent on various tasks by completing the Form and then submit the data as a version. Because the data is stored in each employee's own SQL table in the Content Server database, the payroll department can access it by using an external program that computes the employee's pay by extracting the Form information from the table. Also, each employee can view the card's Versions to review past time cards. For more information about accessing Form Versions, see Working with Forms.

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