← Return to the list of available actions
If you have trouble understanding how the action works, check the descriptions: Action, Conditional execution, Component parameters
Basic information
Category: Currency
Action location: Table
Available from version: 1.0.X
Description
The action collects the value of PLN exchange rate for each row. Additionally, they can save the table number and / or the table symbol taken from the NBP. Data are downloaded directly from the NBP website. The component starts up changing the column value given above in the parameters "Currency code" and "Date of exchange rate"
Configuration parameters
| Name of the parameter | From version | Description | Parameter type | Default value | Field type | Notes and restrictions |
|---|---|---|---|---|---|---|
| Currency code* | 1.0.81 | Column containing currency codes in ISO format (currency codes are available on the NBP)website), e.g. EUR, USD | An array of text variables | Editable field | ||
| Date of exchange rate* | 1.0.81 | Column in the table with the date of the exchange rate | An array of date variables | Editable field | ||
| Exchange rate* | 1.0.81 | A column in the table to save the course value | An array of floating point variables | Editable field | ||
| Table number | 1.0.81 | Column for entering the table number from which the exchange ratewas taken | An array of text variables | Editable field | ||
| Table type | 1.0.81 | Column for writing the table type from which the exchange ratewas taken | An array of text variables | Editable field | ||
| Line condition | 1.0.81 | The function called for each line. The type of function being returned is logical | Function | Editable field | Possibility of using the tabular variable "Row index" | |
| Day shift* | 1.0.106 | Modify the date of downloading the course (adds / subtracts the number of days from the given date) | Integer | Editable field | Modifies the date of downloading the courses for all the rows in the table Example: | |
| NBP Bank timezone | 1.0.135 | Use polish NBP Bank timezone instead of a server timezone. | Boolean | No | Dropdown list |
Parameter*- required field
Sample configuration
Change log
1.0.81 (applicable documentation)
- Adding component
1.0.98
- Adding a comment in the popup in case of an error
1.0.106
- Adding day shift parameter
1.0.135
- Added "NBP Bank timezone" parameter