Data Add Record
Last updated
Last updated
Data Add Record is a regular block that initiates the addition of a record into 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 Data: 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 addition, which will occur in the background. To track the status and to take an action upon completion, use the Data Status block.
The image below shows an example of Data Add Record the block.
Here is a summary of the above example:
The Event Action block is used to handle a click event for a button.
The Data Add Record block is used to add a new record into the Customers database table. The record is for the name Jane Max .
The Data Status block is used to track the completion of the database add operation.
Upon a successful completion, the Show Information Popup block is used to display the record identifier of the newly added record along with the value of the FirstName field.
The result for the above example is shown in the image below. The record identifier for the newly added record (64f1018ab5ed96040cc633b3) is displayed along with the value of the FirstName field.
The Customers database table now contains the following, with the record we added highlighted:
