Save Record

The SaveRecord action allows you to execute UPDATE and/or INSERT commands without creating an SQL action.

Select the element to which you want to add the action. Click on +Add Action under the Properties panel. (A)

Click OnClick--> ManageDB-->Save Record and create the Save Record action. (A)

The SaveRecord action has 3 modes: Smart, Insert, and Update.

1.Smart Mode:

If the Id you send with the action matches an Id in the table, it will run UPDATE; if it doesn't match, it will run INSERT.

2.Update Mode:

If there is an entry in the table that matches the given Id, it updates the entry; if not, it doesn't take any action.

3.Insert Mode:

If there is no entry in the table that matches the given Id, it adds the entry to the table; if there is, you get an error.

After selecting the mode, you need to choose a table. Immediately after your table selection, a MultiSelect will appear under the Select you used to choose the table. This MultiSelect will contain the columns in the table you selected. These columns, along with the table selection, will appear as parameters within the action.

For every column you select, the columns will be added to the action as parameters. You can execute the data binding operation for the added parameters using the Symbol Picker next to them.

Update condition in Update mode:

If Update mode is selected in the action, a field will appear below the action representing the conditions under which table entries should be updated.

Multiple conditions can be added to this field. These conditions can be chained back-to-back with an AND Clause, or an OR condition group can be created, allowing the action to work if any of the conditions are met. Multiple OR condition groups can also be created and chained back-to-back.

Within the created action, Symbol Picker (B) is used to select the parameter input method for the action.

You can perform various operations on the Context menu (C) for the actions you create.

You can easily copy the action with the Copy option. This way, you gain speed where action repetition is required.

You can add a message for the user with the Add Confirmation option,

With Add Condition, you can bind this message to a condition.

You can easily delete the action created with the Remove option.