Data grid

A table that is possible to edit direct in the ongoing workflow.

Prompt The label displayed above the data grid.
Source Choose a source or leave it empty.
Columns Click on edit to add or modify columns in the grid. Read more about configuration of columns below.
Allow Add Check this box if it should be possible to add new rows to the data grid.
Allow Delete Check this box if it should be possible to delete rows from the data grid.
Use Change Tracking A variable RowState will appear when this checkbox is checked, this variable can have four different states:
- Unchanged - when the row in the data grid is unchanged
- Changed - when the user have change something on the row in the data grid
- Added - When the user have added a new row (when the row is new)
- Removed - When the user have removed the row
Use the variable RowState to handle new, modify and delete in scripts.
Example:
```
If @RowState = 'Changed'
Begin
Update OrderLines
Set Qty = @Qty
Where OrderNo = @OrderNo and OrderRowId = @OrderRowId
End;
```
```
If @RowState = 'Removed'
Begin
Delete from OrderLines
Where OrderNo = @OrderNo and OrderRowId = @OrderRowId
End;
```
Row Selection Mode Enables the possibility to select one or multiple rows:
- No selection - not possible to select any row
- Single selection - only possible to select one row
- Multi selection - one or more rows can be selected
The grid is by default set to No selection. Calendar grid and grid in CE client are out of scope.
Selected rows are fetched in a Scrip Step (or Assignment Step) after the grid User Step using the variable IsSelected. The target variable from the script step is then used in as the source when the selected data is to be used.

Target Variable The name of the new variable in which the data is stored as a table.

Item Style Use a case statement to set row color based on a condition. Also see Cell Color under All Columns. CE client is out of scope.
Example:
```
{case when objStatus = 'Planned' then 'PURPLE' 
      when objStatus = 'Released' then 'GREEN' 
      when objStatus = 'Rested' then 'RED' 
      else '' end}
```
Colors: GREEN, RED, YELLOW, BLUE and PURPLE

Columns

Click EDIT to configure the columns in the grid. The Add All Columns button will add all columns in the Source in one click, Remove All Columns will remove them all. Use + or - respectively to add or remove a single column. In a calendar grid a mandatory date column is always added by default, this column is not affected by the Add/Remove All functionality and is not possible to remove.

Edit columns settings:

All Columns The following settings are available for all column types:
- Title: Enter a title for the column.
- Size Mode: Size mode can be set to Break, Clip or Fit (for CE client Clip and Fit are available):
  - Break - Break works like word wrap, ie the column width is defined by the Size setting and the text then continues on multiple rows to the maximum height of 85% of max grid height. Uses ellipsis function to indicate omission of text.
  - Clip - Clip mean that the text is clipped according to size setting. No wordwrap. Uses ellipsis function to indicate omission of text.
  - Fit - Fit means that the column width is fitted to the largest value displayed in the column - up to approx. 85% of grid width. Fit overrides the Size setting. Uses ellipsis function to indicate omission of text.
- Size: Decide what width of the column. Sizes: Small, medium, large.
- Cell Color: Use a case statement to set cell color based on a condition, also see Item Style above. Available colors are: GREEN, RED, YELLOW, BLUE and PURPLE. CE client is out of scope.
Text Column Enter a title of the column and a variable name, for example First name as the title and firstName as the variable name. Choose a value type, which represents that type of data that the column should hold. Decide the appearance of the column if the data should be editable, hidden and/or mandatory.
- Hidden: Check this if the column should be hidden and not showed to the user.
- Editable: Check this if the column should be editable for the user.
- Default Value: Enter a default value.
- Editable For New Rows: Check this if the column only should be editable when adding new rows.
Numeric Column Enter a title of the column and a variable name, for example First name as the title and firstName as the variable name. Choose a value type, which represents that type of data that the column should hold. Decide the appearance of the column if the data should be editable, hidden and/or mandatory.
- Format String: Numeric format strings are used to format common numeric types. Using the C modifier in the format string area converts the numeric input into local currency. Also the hashtag symbol (#) represents one number in the total numeric value, so one can format the 6-digit value 123456 with inputs in the following way: First two numbers: ## Second two numbers ## Last three Numbers ## Result: First two numbers 12 Second two numbers 34 Last three numbers 56 Read more about formatting here
- Hidden: Check this if the column should be hidden and not showed to the user.
- Editable: Check this if the column should be editable for the user.
- Default Value: Enter a default value.
- Editable For New Rows: Check this if the column only should be editable when adding new rows.
Value List Column Enter a title of the column and a variable name, as in below example Food as the title and food as the variable name, check Include in Output to include the variable in the target variable of the grid.
- Table Expression: Connect a table to the value list, the result of the below example will be based on what the user have selected in the catalog value list.
- Row Text: Enter the variable that represents the value that should be showed in the value list.
- Key Expression: Enter a variable here (for example an id) and use Output Key Only to just get the one variable instead of a record.
- Output Key Only: Check this to get a variable with the Key Expression.
- Editable For New Rows: Check this if the column only should be editable when adding new rows.

Computed Column Enter a title of the column and a variable name, for example sum as the title and sumValue as the variable name. The computed column can for example be used as a summary column. If the grid have one column with a price and one with a discount, then the columns can be summarized in the computed column. Do the calculation ({price - discount}) of the variables price and discount in the template field and choose what value type the column should have.
- Value Template:
- Hidden: Check this if the column should be hidden and not showed to the user.
Checkbox Column Enter a title of the column and a variable name, for example Invoice as the title and invoice as the variable name. Decide if the checkbox should be check by default or not.
- Editable: Check this if the column should be editable for the user.
- Default Value: Enter a default value.
- Editable For New Rows: Check this if the column only should be editable when adding new rows.

PreviousImage selection input NextCalendar

Last updated 4 years ago