← Return to the list of available actions
If you have a problem understanding how the action works, check: Action, Conditional Execution, Components parameters.
Basic information
Category: Table
Action location: Table, Table button
Available from version: 1.0.0
Description
The action enables importing data from an excel file to a dynamic table. The action configuration allows you to specify which columns are to be moved and it is possible to filter them. Filtering can only be done on columns that are imported. If you place an action on a dynamic table, the action creates an import button.
Action call-up
Leaving an empty conditional field is equal to setting it to "true".
Action location | Conditional execution parameter action | Action call-up condition |
|---|---|---|
Table | Activates the button | Pressing button |
Table button | Activates the button | Pressing button |
Configuration parameters
Parameter name | From version | Description | Paremeter type | Default value | Field type | Comments and restrictions | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Filter columns* | 1.0.0 | Columns that will be included in the given filtering | Array of variables |
| Editable field |
| ||||||||
| Filter Type | 1.0.0 | An array of text values | Drop-down list | Available filtering: ==,! =, <,>, <=,> = | ||||||||||
| Filter Value | 1.0.0 | This function is a prerequisite for blocking / unblocking specific fields in a given row based on values from other fields. The function can use the context variable "Selected row". | An array of functions | Editable field | Appears only when you place the action on a dynamic table. Only accepts functions returning a boolean value. | |||||||||
| Columns to import | 1.0.0 | Imports only specified columns (if none are provided - imports all) | Array of variables | Editable field | ||||||||||
| Checkbox "Clear"* | 1.0.4 | The parameter determines whether a checkbox should appear in the import window with the option to clear the table before importing. | Boolean | Yes | Editable field | |||||||||
| Import hidden columns | 1.0.40 | It allows you to import hidden columns that are hidden in a dynamic table in a given task. | Boolean | No | Editable field | |||||||||
| Auto-complete dynamic lists* | 1.0.52 | Allows you to enable auto-mapping for all lists, for selected ones and disable for all. | Text | ENABLE_ALL | Drop-down list | To choose from:
| ||||||||
| Dynamic lists | 1.0.52 | The parameter specifies for which dynamic lists auto-mapping should be enabled. | Array of variables | Editable field | The parameter appears for the parameter "Auto-complete dynamic lists" on "Enable for selected" | |||||||||
| Form save* | 1.0.69 | Specifies whether to save the form after downloading the data to the table | Boolean | Editable field | ||||||||||
| Accept the job after loading the data | 1.0.100 | Boolean | No | Editable field | ||||||||||
| Action name | 1.0.100 | Accept button identifier on the form | Text | Editable field |
Parameter*- mandatory field
Configuration example
For table:
For table button:
Change log
1.0.0
- Adding a component
1.0.4
- Addition of the "Clear" Checkbox parameter
1.0.40
- Allow you to import hidden columns
1.0.44
- Filtering fix
1.0.52
- Added the AutoComplete dynamic list parameter
1.0.62
- Adding the option of placing the action on the table button
1.0.69
- It is possible to set whether the data should be saved after downloading
1.0.99
- Adjusting action to the new builder
1.0.100 - Option to accept a task after import has been added
Add Comment