The SaveRecord action is the action that allows you to run UPDATE and/or INSERT commands without creating a SQL action.
Click +Add Action under the Properties panel.(A)
Click OnClick--> ManageDB-->Save Record and add the Save Record action.(A)
Save Record action has 3 modes. These are; Smart, Insert and Update.
1.Smart Mode:
If the Id you send with the action matches an Id in the table, it allows you to run UPDATE, if not, INSERT.
2.Update Mode:
If there is an entry in the table that matches the given Id, it updates the entry, otherwise it does not take any action.
3.Insert Mode:
If there is no entry matching the Id given in the table, it adds the entry to the table, and if there is, you will get an error.
After the mode selection, you need to select a table. Immediately after your table selection, a MultiSelect will appear under the Select you selected table. In MultiSelect, the columns in the table you have selected will appear. These columns will take place in the action as parameters depending on the table with the table selection.
After each column selection you make, the columns will be added as parameters to the action. You can perform data binding to the added parameters with the Symbol Picker next to it.
Update condition in Update mode:
If the action has Update mode selected, a field will appear at the bottom of the action representing which table entries the action should update that meet which conditions.
More than one condition can be added to this field. These conditions can be chained back to back with AND Clause or an OR condition group can be created and the action can be executed if any of the conditions are met. At the same time, more than one OR condition group can be created and these condition groups can be chained consecutively.
Click Symbol Picker (B) to fill in the parameters in the added action.
When all parameters are filled and the action is executed, the entry of the selected table corresponding to the selected Id, if any, will be deleted.
You can perform various operations for the added actions via Context Menu (C).
You can easily copy the action with the Copy option. Thus, you gain speed where action repetition is required.
With the Add Confirmation option, you can add a confirmation message for the action to work,
With Add Condition, you can determine that the action you add works in accordance with a certain condition,
You can easily delete the action added with the Remove option.