A text box is displayed in the cell in which the line item amount of a cell is calculated automatically. The user can select up to three columns. Their values are multiplied to calculate the line item total.
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 |
DB field |
Selection of database fields of type: VARCHAR, INT, BIGINT. DECIMAL, or TEXT |
Settings |
|
Net price per unit |
Selection of the column containing the net price per unit |
Quantity |
Selection of the column containing the quantity |
Control key |
Selection of the column containing the control key |
Sum? |
Automatic calculation of a total for this column |
Width |
Width of the column in pixels |
Hidden? |
The element is integrated but hidden in the view. |
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 |
Color |
|
Label color |
Color of the label |
Background color |
Background color of the element |
Text color |
Text color of the element |
Please note: For the calculation of the item amount, columns of the type decimal or integer must be used. For other element types, a validation for numeric and decimal values must be carried out so that the entries are correct and a calculation can be made.
