A default textbox is created in the cell for displaying and inserting values.
Please note: Before using this form element, read the chapter Instructions for working with SQL fields in JobRouter carefully.
Please note: If you want to refer to a column from a subtable view, the following notation is generally required: [<subtableViewName>_<columnName>]
SELECT DISTINCT mimetype FROM JRFILES WHERE mimetype LIKE '%[subtableViewFileDetails_mimetype]%'
Property |
Description |
|---|---|
Name |
Element name |
Label |
The label becomes the column header |
2nd label |
The label displayed behind the element |
Info Text |
Text to be displayed in the balloon |
Default value |
Preassigned value |
Database link |
Selection of a JobRouter database link |
SQL |
SQL query to be executed against the database (see example). |
Database field |
Selection of database fields of type: VARCHAR, INT, BIGINT, and TEXT |
Settings |
|
Width |
Width of the textbox in pixels |
Read-only? |
The textbox is write-protected. |
Disabled? |
The textbox is disabled. |
Required? |
An entry is necessary here to forward the step. |
Hidden? |
The element is integrated but hidden in the view. |
Alignment |
Text alignment |
Scripting |
|
OnBlur |
Script to be executed when the cursor leaves the element |
OnChange |
Script to be executed when the value in the element changes |
OnClick |
Script to be executed when the element is clicked |
OnFocus |
Script to be executed when the element gets focus |
OnKeyDown |
Script to be executed when characters are input into the element |
Color |
|
Label color |
Color of the label |
Background color |
Background color of the textbox |
Text color |
Text color of the textbox |
