eForms Solution for allowing common business forms to be placed on a company intranet, where they may be filled in, reviewed, and approved or processed, according to security settings. The benefits of Forms Online are: Eliminates the need for manually creating the HTML form This form can then be filled in and the data stored in a database table, without having to create code or CGI scripts to connect the form to a database table. Forms Online uses a superset of the security system

Content Topics Eliminates manually creating HTML Form Security Example Form

Eliminates the need for manually creating the HTML form

A form is defined by entering a definition into a database table (online via the browser) and this definition creates the form dynamically when needed.

Forms are defined through a simple definition table, with no custom coding required! Fields of different types can be added to forms as required, and the layout of the form is easily modified, again WITHOUT coding. A simple hyperlink is added to the appropriate web page to enable access to the form.

Form data is stored in a database, which can easily be reported as required, for example to report on the results of a survey form.

Form Security

Forms Online uses a superset of the security system to not only control who can access which forms, but also which form entries they can see: a user can be set up to be able to only enter new information into a form, to view his own form entries, to view all form entries, to update either his own or all form entries, and finally, to be able to approve and/or disapprove form entries.

Example Form

For example, a Vacation Request Form can be easily defined that allows any employee to fill out a vacation request online. He/she may review only their own forms, until a manager approves the request. A manager can easily call up a list of forms requiring review and approve or deny requests online, where the results are immediately available to the employee.

In this example it would also be easy to integrate these approvals into a corporate or departmental calendar (this is an excellent example of where the extension layer of database objects would be used.)