Data Update Record with ID
Last updated
Last updated
Data Update Record with ID is a regular block that initiates the modification/update of a record in a database table.
The block consists of the following (from top to bottom):
Table: Value Parameter that accepts a text value representing the name of the Database Table .
Dataset Name: Value Parameter that accepts a text value representing the name of the dataset. This can be any text value and can later be used to track the completion.
Dataset Refresh: Value Parameter that accepts a boolean (true/false) value to indicate if you want the system to refresh the records in the same dataset after successful completion.
Record ID: Value Parameter that accepts a text value representing the identifier for the record being modified/updated.
Set fields to: Value Parameter that accepts an object value representing the record to be added. The Object block is pre-attached by default and its properties are automatically populated based on the fields of the selected table.
NOTE:
This block initiates the database record update operation, which will occur in the background. To track the status and to take an action upon completion, use the Data Status block.
For the Set fields to value parameter, you only have to provide values for the fields you want to modify/update and can leave the other fields unassigned.
The image below shows an example of Data Update Record with ID the block.
In this example we will be modifying the Notes field for the record with identifier 64f1018ab5ed96040cc633b3 . As this is the same record we added in the example for the Data Add Record block, please take a moment to go over that example.
Here is a summary of the above example:
The Event Action block is used to handle a click event for a button.
The Data Update Record with ID block is used to modify/update the record with identifier 64f1018ab5ed96040cc633b3 in the Customers database table. The record is for the name Jane Max .
Only the Notes field has a value specified (Modified Notes). All other fields do not have any value assigned. This will ensure that only the Notes field is modified.
The Data Status block is used to track the completion of the database update operation.
Upon a successful completion, the Show Information Popup block is used to display a message that the operation is complete.
The Customers database table now contains the following, with the record we modified highlighted:
