...
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 optiondropdown, you can select a source among various sources from which you want to update records. It allows to choose from Object, Model and Variable. Info | Note: By default, the Source Type is Object. Info | 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 | field fields of choosing specific model | and 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 select amount specify the number of records to update . Either you can choose Single or Multi-recordfrom 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 | It This option enables user to filter out the data for Source Type 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. Info | Note: By default, this field in invisible. It will only be populated if Update Specific Records checkbox is checked.
| |||
Select Fields to Update Data | It enables to filter out the fields which need to be updated using AND OR logical operators. Info | Note: By default, this field in invisible. It will only be populated if Update Specific Records checkbox is checked. | |||
Key Field | It enables to decide which will be key field to track the records. infoNote:
|
Action Details:
...
//Action Details ~ Workflows
Include Page | ||
---|---|---|
|
Input:
...
//Manage Input Variable ~Workflows Modal
|
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.
Info |
---|
Reference: Merge Text |
...
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
For example, you can set the |
...
Add Condition & Group Condition
Condition | Description |
---|---|
Add Condition |
|
Add Group Condition |
|
Include Page | ||||
---|---|---|---|---|
|
Action Details
...
Include Page | ||||
---|---|---|---|---|
|
Input
...
Include Page | ||||
---|---|---|---|---|
|
Panel | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
For example, if a vehicle sales firm wants to propose its price quote to all the opportunities having |