← 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: General
Action location: Variable
Available from version: 1.0.0
Description
The action deletes all rows from the table.
Action call-up
Leaving an empty conditional field is equal to setting it to "true".
Action location | Value of the "Events triggering" parameter | Conditional execution parameter action | Action call-up condition |
|---|---|---|---|
Variable | Calling when variables are changed | Activates action | Changing the variable value to from the "Update variables" parameter. |
| Call after conditional execution condition | Call-up action | The "Conditional execution" parameter will return "true" | |
Button | - | Activates action | Pressing the button |
Configuration parameters
Parameter name | From version | Description | Paremeter type | Default value | Field type | Comments and restrictions |
|---|---|---|---|---|---|---|
Format of generated number* | 1.0.0 | The format based on which the number will be generated. A typical format consists of three elements: a number marker, a separating symbol and a year marker. The numbers in the year and number markers indicate the number of digits to be generated. The year can be two or four digits, but it can also be omitted, as can the separating symbol. | Text | [N4]/[R2] | Editable field | The format must have a number marker. Formatting can also contain text constants. The sample default format [N4] / [R2] allows, for example, to generate number 0001/17 |
| Sequence Name* | 1.0.0 | The name of the new or existing sequence in the system database. | Text | Editable field | If we want to ensure that the number is reset with the new year, it is enough that the name contains the current year. The currentYear () function can dynamically retrieve the current year. An example name using the function can be defined as follows: #concat (test_, toString (currentYear ())). | |
| Target Variable* | 1.0.0 | Variable in which the number will be saved. | Variable | <variable to which the action was moved> (if placed on a variable) | Editable field (Uneditable if on variable) | The variable should be of the text type and placed on the form (not in the dynamic table). |
| Replacing special characters* | 1.0.37 | Specifies whether special characters in the sequence name are to be converted to "_" (the only acceptable special character in all databases except MSSQL). | Boolean | No | Editable field | The sequence name in the Oracle database cannot start with any special characters (even "_")! When the character change option is enabled, one symbol is replaced by one underscore. For example, "T $ .st" = "T__st" and "T @ # $ e% st" = "T___e_st". |
| Events that trigger the action* | 1.0.72 | In this parameter, we specify after which events the action should be triggered | An array of text values | Call after conditional execution condition | Drop-down list | |
| Updating variables | 1.0.72 | In this parameter we specify which variables will trigger the action. | Array of variables | Editable field | The parameter appears when the Invoking option is selected in the Events triggering an action when changing variables |
Parameter*- mandatory field
Configuration example
Change log
1.0.0
- Adding a component
1.0.1
- Adding the ability to generate a unique number under the button
1.0.37
- Addition of the "Convert special characters" parameter and error correction
1.0.56
- Modifying the dynamic form
1.0.72
- Fixing a bug - getting data after form loads
- Adding new parameter "Events that trigger the action"
1.0.73
- Correction of errors caused by a previous patch
x.x
Preventing the action from being set on the accept button
Add Comment