DbFace support to specify a form for the application to accept user's input.

You can build DbFace form from Design Mode or Code Mode.

Drag & Drop Builder#

DbFace has two major types of form controls: layout control and form control.

All form controls must be placed in layout controls.

Form fields#

Single Line#

Single Line allows the user to enter a single line of string data, the user can specify the data type in the property editor. If you specify a data type, before form submission, Dbface will check the input items whether the input items are the specified type, if not, the form will not be submitted.

Date Range#

You can input 2020-05-01 ~ 2020-06-30 to initialize the date range control. As default, Date Range control will use the last 30 days.

Multi Line#

Multi Line allows the user to enter multiple lines of text.

Drop Down#

Drop Down allows the user to select a data in a value list. Drop-down box needs to be specified the data source.

Radio Group#

Radio Group displays a list of all the values, and allows the user to select one value as the form data to submit.

Checkbox#

Checkbox displays a list of all the values, and allows the user to check multiple data to submit.

Multi Select#

Multi Select displays a list of all the values, and allows the user to select multiple values to ??submit.

Static Label#

Static label displays static data that can not be edited.

Text#

The text control can be used as the form description. DbFace integrates CKEditor as rich text editor.

Form field Properties#

To edit the form field properties, click on the "Edit" button, and open the property editor.

Label#

Labels ar text items in front of form field, which can be used for user to identify this form field.

Name#

Form field script name can be used as variables in application scripts by Smarty manner. Such as: {$status}

Required#

This form field must be required. Before submitting, Dbface will check whether the value of this field is empty, if it is, the form will not be allowed to submit.

Disable#

This item can not be edited. Users can not edit this item.

Data Sources#

Only limited value form fields (such as Drop Down, Multi Select, Checkbox, etc.) have datasource options. DbFace supports two kinds of ways to use the datasource: Enter value directly and mapping script. ("Unrestricted" is generally used to preview the script, in fact, generally do not use this.)

Enter value directly:#

the user input datasource directly, one value per line. The value supports "key: value" division format. If this format is detected, Dbface will automatically take the previous value as the form value,the succeeding value as data displayed in the form. Value as a form before submitting value, the latter value data as displayed in the form inside.

Mapping Script:#

Users can use a query to set the data source.

Onchange Script#

Onchange script is general SQL query script.

When the user completes the input and focus are lost, the scripts will be executed and the result will be mapped to the current form control.

Build Form from Code#

If you need to build a form where Checkbox C is revealed If Checkbox B is Checked "No" or any combination of javascript actions and behaviors normally used in form building to make the Form "Smart".

Diving into source code, you can build logic embedded into options & choices for Forms.