Update Records
Overview
The Update Records action modifies existing entries in a database or data source.
This action is typically used to ensure that records remain accurate and up-to-date as workflows progress.
It allows for changing, editing, or replacing information in response to new events or updates within the workflow. This could include changes in status, additional details, or corrections to prior data. By updating records, this action helps maintain data integrity and relevance over time.
Let’s explore the screens that follow, after drag-n-drop of Update Records action on workflow canvas.
Config
Config Field | Description |
---|---|
Source Type | In this dropdown, you can select a source among various sources from which you want to update records. Note: By default, the Source Type is Object. Other options include Model and Variable. |
Note: Fields below this will be populated based on the Source Type one chooses. If Variable and Model are chosen, only two fields of choosing specific model as well as variable and Key Field will be populated. | |
Object | In this option, you can select the object from which you want to update records. The chosen object will define the source of data for updation. Note: Label of this field is dependent on Source Type chosen earlier. If chosen variable or model, label will be the same either variable or model as per selection. |
How many records to store? | In this option, you can specify the number of records to update from the selected object. You can choose to update either a single record or multiple records based on your operational needs.
|
Update Specific Records | Check if you want to update only specific records. |
Filters | This option enables user to filter records data from the selected object using AND and OR logical operators. These operators allow the user to create complex logic for updating records, ensuring that only the relevant data is updated. |
Select Fields to Update Data | It enables to filter out the fields which need to be updated using AND OR logical operators. |
Key Field | It enables to decide which will be key field to track the records. |
Filters
Custom Logic for Multiple Filters
Additionally, you can add multiple filter conditions and define custom logic for how they should be evaluated.
AND: Provide results If all provided conditions are true
OR: Provide results If one of the provided conditions are true
Value Configurations
In this section, provide a value to compare or check against the selected field. You can provide a value by clicking on the gear icon. It opens up a screen to provide value using merge text.
Add Condition & Group Condition
Condition | Description |
---|---|
Add Condition |
|
Add Group Condition |
|
Action Details
Input