Kuika's Save Record action is used to save changes made on a form or data entry screen to the database. In case the data collected through a form is updated or a new record is added, it ensures that this data is written to the database. On the Kuika platform, the Save Record action works by integrating with database systems such as MSSQL and Oracle, so businesses can continue data management flexibly without changing their existing database infrastructure. In this course, you will learn how to successfully save data from a form using the Save Record action.
Save Record action supports web and mobile applications.
Add Save Record Action
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.
