The Save Record action is used to save changes made on a form or data entry screen to the database.
With this action:
- You can update the data collected through a form or add a new record.
- By integrating with database systems such as MSSQL and Oracle, you can maintain data management without changing the existing database infrastructure.
Save Record action is supported in web and mobile applications.
Add Save Record Action
- Log in to the Kuika platform and open the project you will work on from the Apps screen.
- Switch to the UI Design module and open the Properties panel on the right side.
- Click on the + ADD ACTION drop-down menu.
- Select Initial Actions → Managed DB → Save Record.
Save Record Action Modes
The Save Record action has three different modes:
- Smart:
- If the Id sent with the action matches an Id in the table, UPDATE is executed, if not, INSERT is executed.
- Insert:
- If there is no record in the table that matches the given Id, it creates a new record.
- However, if there is a record matching the given Id, an error is received.
- Update:
- If there is a record in the table that matches the given Id, the record is updated.
- If there is no matching record, no action is taken.
Table Selection and Conditions in Save Record Action
- If “Update” mode is selected in the action, a field will appear below the action representing the table entries that need to be updated.
- Multiple conditions can be added to this field.
- Conditions can be chained together with AND structure.
- Alternatively, an OR condition group can be created so that the action runs when any condition is met.
Table Selection
- Select the table to be used for registration from the “Select Table” field.
- In the “Multi Select” window, the columns of the selected table will be listed.
- These columns are defined as action parameters depending on the table and determine the functionality of the action.
By following these steps, you can successfully configure the Save Record action on the Kuika platform.
