Data Update Record with ID
Last updated
Last updated
Data Update Record with ID
is a that initiates the modification/update of a in a .
The block consists of the following (from top to bottom):
NOTE:
The image below shows an example of Data Update Record with ID
the block.
Here is a summary of the above example:
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 Customers database table now contains the following, with the record we modified highlighted:
Table: that accepts a value representing the name of the .
Dataset Name: that accepts a value representing the name of the dataset. This can be any value and can later be used to track the completion.
Dataset Refresh: that accepts a (true/false) value to indicate if you want the system to refresh the records in the same dataset after successful completion.
Record ID: that accepts a value representing the identifier for the record being modified/updated.
Set fields to: that accepts an 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.
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 block.
For the Set fields to , you only have to provide values for the fields you want to modify/update and can leave the other fields unassigned.
NOTE: Please refer to the prerequisite information shown before seeing the example.
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 block, please take a moment to go over that .
The block is used to handle a event for a button.
The block is used to track the completion of the database update operation.
Upon a successful completion, the block is used to display a message that the operation is complete.