This example uses a simple form to collect information into a database table.
Using the Visual Designer
The form can be created in a drag-and-drop point-and-click manner, without writing any code, simply by the using the Visual Designer Tool.
Elements that relate to specific database columns can be dragged to the Designer canvas directly from the Database Tab.
To specify how form information is saved, a routine must be created.
This can be done by right-clicking an element, like the Submit Request button, and selecting the "Build Logic..." menu option.
A routine is a series of steps.
This application only has one routine, but it's possible to create multiple routines that are triggered by different events within an application.
Each step is created by answering some questions.
While this is not necessary in most cases, it gives you the ability to define custom or advanced functionality for your application.
Using Validation and Database-driven Choices
Some application functionality can be specified when creating widgets in the Visual Designer, rather than by using routines. For example, in the Properties Window, you can mark fields required, or you can specify other validation requirements, such as a field must be in the form of an email address.
Your widgets can also be tied to data from database tables. For example, the Type of Problem dropdown reads its choices from a database. This is configured by using the Database-driven Selection properties on the dropdown widget.