A checkbox is displayed in the form. Whether the checkbox is checked or not depends on the result of the SQL query.
If a SQL query returns no total row or a result value of 0 or "" (empty string), the checkbox will be cleared. If the SQL query returns a total row with a different value the checkbox is marked.
Please note: Before using this form element, read the chapter Information about working with SQL fields in JobRouter carefully.
Property |
Description |
|---|---|
Name |
Element name |
Label |
Label that appears in the left column |
2nd Label |
Label that appears after the element |
Info Text |
Text to be displayed in a balloon |
Database connection |
Select the JobRouter database connection |
SQL Query |
SQL query to be executed against the database |
DB field |
Selection of database fields of type: VARCHAR, INT and BIGINT |
Disable storage |
When saving or sending the value of the element is not stored in the database by the form |
Settings |
|
Disabled? |
The checkbox 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 checkbox must be checked that the step can be sent |
Hidden? |
The element is hidden in the form |
Scripting |
|
OnClick |
Skripts that are executed when the element is clicked. |
OnChecked |
Scripts that are executed when setting the element |
OnUnchecked |
Script to be executed when the checkbox is cleared. |
Color |
|
Label color |
Color of the label |
