In our last article we solved the problem of the missing Shipping Address on Account records by copying the Billing Address every time a record was created or updated. This unfortunately does not completely solve the problem as we may have many thousands of records that have not been updated and are still missing a Shipping Address.
Because we potentially have many thousands of records to update, we need to be careful not to exceed our limit of resources we have on our Salesforce org. These are known as Governor Limits and exist to make sure that any complex process one customer runs does not impact other customers that share the same resources.
By using a scheduled triggered flow our process can group records to be updated into blocks of 200 records and we have a daily limit of 250,000 records that can be updated this way.
Step 1: Start Flow
From the setup menu, select -> Flows
Step 2: Create a new flow
From the Flow screen, click New Flow (top right of page).
Select the Schedule-Triggered Flow from the choices (1)
Click Create (2)
Step 3: Set a schedule to run the flow
Click Set Schedule:
Set the date and time to run the flow and select the frequency – once will be enough if we have less than 250,000 Account records to be updated.
Note: If we have more than 250,000 Account records then we will need to adjust the conditions in Step 4 (below) and add an extra criterion to reduce the number of records processed each time. We may be able to use the year the record was created, the billing country or some other Account field to restrict the number of records and run this process several times (a day apart), adjusting these criteria each time until all records have been updated. The 250,000 records are a daily limit, hence the need to run subsequent processes a day later.
Step 4: Choose object and conditions
Unlike the Record Triggered flow, we need to test each individual field of the Shipping Address:
Select the Object – Account (1)
Select the fields (2) the Is Null operator (3) and the True value (4) for each of the five Shipping Address fields.
Note: Is Null equals true means the field is blank.
Step 5: Configure the Update Records
Select the “+” symbol under the start element and add an Update Records element.
Configure the Update Records as follows:
Give it a label (1) and add a description (2)
Select Use the account $Record global variable (3) so we can access the field values of the existing record.
Select the None – Always Update Record condition as we have already specified our conditions in the start element.
Select the Shipping address values on the left (5) and the matching billing filed under the $record on the right (6). Do the same for all five fields.
Save and activate the flow.
When the scheduled time rolls around the flow will be triggered and run. Wait a couple of minutes after the scheduled time and check some records (with blank Shipping Addresses) and the Shipping Address fields should have been updated.
This is just a sample of the many things you can do with Salesforce Flow. If you need some help with this example or have a similar requirement, the San Diego Salesforce Consultants at KeyNode Solutions can help you out. Drop us a line at hello@keynodesolutions.comor call us at 1-858-215-5371
Top Benefits of Hiring a Salesforce Consulting Partner
At KeyNode Solutions we frequently get asked the age-old question of should you hire a Salesforce Consulting Partner. It is no secret that implementing Salesforce can be a complex and time-consuming process. This is [...]
How Much Does a Salesforce Consulting Partner Cost?
Determining the exact cost of a Salesforce Consulting Partner such as KeyNode Solutions, is not as straightforward as buying a gallon of milk at the grocery store. The price can fluctuate widely based on [...]
What Is a Salesforce Consulting Partner?
Salesforce Consulting Partner: Your Guide to Success At KeyNode Solutions, an experienced Salesforce Consulting Partner, we are often asked what a Salesforce Consulting Partner is and how we can help a business become more [...]
Why Is Salesforce Booming?
Salesforce, a cloud-based software company founded in 1999 by Marc Benioff, has emerged as a world leader in the customer relationship management (CRM) space, driving significant growth and transformation in the technology industry. KeyNode [...]
Why Do Companies Love Salesforce?
Salesforce has become a cornerstone for more than 150,000 businesses around the world in a variety of sizes and industries. Its popularity can be attributed to several key factors that resonate deeply with companies [...]
Why Hire a Salesforce Consultant
Salesforce is a powerful customer relationship management (CRM) platform that can maximize how your business functions. But with Salesforce’s complexity and vast array of features, implementing and maximizing its potential can be daunting. For [...]