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

image-20240819-040920.png
Config Tab

Config Field

Description

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.

  • Single Record: Updates only one record from the object, typically the first matching record.

  • Multi-Record: Updates multiple records.

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

image-20240905-114823.png
Filter: Single and Multiple Conditions

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

Condition

Description

Add Condition

  • The Add Condition feature allows users to define multiple criteria that must be met for a validation rule to trigger.

  • This feature is used to create complex logic by combining different conditions that Salesforce evaluates before allowing a record to be saved.

Add Group Condition

  • The Add Group Condition feature allows users to group multiple conditions together, creating complex logic that involves different sets of criteria.

  • This feature is particularly useful when combining conditions that should be evaluated as a unit (logical OR within a group) or when nesting conditions for more advanced logic.

Action Details

Input