The element creates a standard input field in the form for entering values and for displaying the results of a SQL query.
Please note: Before using this form element, read the chapter Information abput working with SQL fields in JobRouter carefully.
Property |
Description |
|---|---|
Name |
Element name |
Label |
Label that will appear in the left column |
2nd Label |
Label that appears after the element |
Info Text |
Text to be displayed in a balloon |
Default value |
Value, if the assigned database field is empty |
Database connection |
Select the JobRouter database connection |
SQL |
SQL query to be executed against the database |
DB field |
Selection of database fields of type: VARCHAR, INT, BIGINT and TEXT |
Disable storage |
When saving or sending the value of the element is not stored in the database by the form |
Settings |
|
Width |
Width of the column in pixels |
Read-only? |
The input field is read-only |
Disabled? |
The input field is disabled
Please note that functions of the JavaScript API (e.g. jr_set_value) do not have any effect on saving this value by enabling this option |
Required? |
The user must enter something into the field that the step can be sent |
Hidden? |
The element is hidden in the form |
Align |
Text alignment |
Scripting |
|
OnClick |
Scripts that are executed when you click the element. |
OnChange |
Scripts that are executed when the element value is changed |
OnFocus |
Scripts that are executed when focusing the element |
OnBlur |
Scripts that are executed when leaving the element (when it loses focus) |
OnKeyDown |
Scripts that are executed when characters are entered |
Color |
|
Label color |
Color of the label |
Background color |
Background color of the textbox |
Text color |
Text color of the textbox |
