After logging into the Kuika platform, open the project you will work on from the “Apps” screen.
While in the “UI Design” module, open the “Properties” panel on the right side.
Select “Initial Actions → Managed Db → Save Record” from the “+ADD ACTION” drop-down menu.
Save Record action has 3 modes:
Smart: If the Id you send with the action matches an Id in the table, it allows you to run “UPDATE”, if not, it allows you to run "INSERT”.
Insert: If there is no entry in the table that matches the given Id, it adds the entry to the table. However, if there is an entry that matches the given Id, an error is received.
Update: If there is an entry in the table that matches the given Id, it updates the entry. Otherwise no action is taken.
If Update mode is selected in the action, a field representing the table entries that need to be updated will appear below the action. More than one condition can be added to this field. The conditions can be chained together with the "AND" structure or an "OR" condition group can be created to ensure that the action will run if any condition is met.
5. After selecting the mode, select the table from the "Select Table" field. In the "Multi Select" window, the columns of the table you selected will be listed. These columns are included in the actions as parameters depending on the table and are used to define the functionality of the action.