Last Updated on December 13, 2020 by Rakesh Gupta
Big Idea or Enduring Question:
How to use Process Builder to automate business scenarios that involve cloning an existing record.
Objectives:
After reading this blog, you’ll be able to:
- Understanding the Record Create Process in Process Builder
- Understanding how to clone a record by using the create record option.
- Using a custom field to restrict the process builder to fire only once when a condition is met.
- Using the formula in filter condition in the process.
Business Use case
Steve Cartwright is working as a System Administrator at Universal Containers (UC). He received a requirement to auto-create a new Opportunity (Similar to an old record) whenever an Opportunity is successfully closed and set the Close date for the new Opportunity to 120 days from the old opportunity’s close date.
Automation Champion Approach (I-do):
Usually, with Salesforce multiple approaches are available to solve a business requirement. Choose the ones that are simple, straightforward, and consume fewer resources.
Similarly in this scenario, either use Apex trigger, a combination of Flow and Process Builder, or a few more.
Let’s solve this scenario using Process Builder, as this business case involves only one level of cloning. To implement deep clone (Multilevel cloning), either Lightning Flow or Apex Programming can be used.
Before we dive into the solution to help Steve, though, we need to first understand what is Process Builder and its components.
The solution involves two steps.
- Create a checkbox field to ensure the process builder is fired only once after it meets a criteria. So, the checkbox field is used as a flag to hold a boolean value
- Create a record change process and use the Create record action to clone a record whenever a specified criteria is met.
Before diving further, let me show you a diagram of a Process Flow at a high level. Please spend a few minutes to go through the following Flow diagram and understand it.
Let’s begin building this automation process.
Guided Practice (We-do):
There are 6 steps to solve Steve’s business requirement using Process Builder. We must:
- Creating a checkbox
- Define process properties
- Define evaluation criteria
- Define process criteria
- Add action – create a record
- Add action – update records
Step 1: Creating a Checkbox
- Click Setup.
- In the Object Manager, type Opportunity.
- Select Fields & Relationships, then click New.
- Select Checkbox as Data Type, then click Next.
- Enter Field Label and click the Next button. The Field Name will populate.
- As a best practice, always input a description.
- Set the Field-level Security for profile, make sure to set this field as read-only.
- Don’t add this field to the Page Layout.
- Click Save
Step 2: Define Process Properties
- Click Setup.
- In the Quick Find box, type Process Builder.
- Select Process Builder, then click New.
- Name the Process and click the Tab button. The API Name will populate.
- As a best practice, always input a description.
- The process starts when A record changes.
- Click Save.
Step 3: Define Evaluation Criteria
- Click on the Add Object node to begin selecting the evaluation criteria.
- Select the Opportunity object from the dropdown list.
- Start the process when a record is created or edited.
- Click Save.
Step 4: Define Process Criteria
- Click the Add Criteria node to begin defining the process criteria.
- Name the criteria.
- The criteria should execute actions when the conditions are met.
- Set Conditions
- Row 1:
- Field: Opportunity | Stage
- Operator: Equals
- Type: Picklist
- Value: Closed Won
- Row 2:
- Field: Opportunity | One Time Activity
- Operator: Equals
- Type: Boolean
- Value: False
- Row 1:
- Select All of the conditions are met (AND).
- Click Save.
Step 5: Add Action – Create a Record
- Below Immediate Actions, click Add Action.
- For Action Type, select Create a Record.
- Name the action.
- Select the Opportunity record type.
- Set Field Values:
- Row 1:
- Field: Close Date
- Type: Formula
- Value: [Opportunity].CloseDate + 120
- Click Add Row
- Row 2:
- Field: Name
- Type: Formula
- Value: [Opportunity].Name +” + “
- Click Add Row
- Row 3:
- Field: Stage
- Type: Picklist
- Value: Prospecting
- Click Add Row
- Row 4:
- Field: Forecast Category
- Type: Picklist
- Value: Pipeline
- Row 1:
- Click Save.
Step 6: Add Action – Update Records
- Below Immediate Actions, click Add Action.
- For Action Type, select Update Records.
- Name the action.
- Select the option Select the Opportunity record that started your process record type.
- Criteria for Updating Records: No criteria – just update the records!
- Set Field Values:
- Field: One Time Activity
- Type: Boolean
- Value: True
- Click Save.
Almost there! Once everything looks good, click the Activate button.
Now onwards, a new opportunity will be automatically created whenever (only once) an opportunity is updated as Closed Won.
Note:- Before you activate your process, you have to make sure that you have assigned data in the correct format because Process Builder obeys validation rules. If some fields are required by using validation rules, then make sure you have added those fields. Conversely, if some fields are required on the page layout, you can ignore those fields.
Formative Assessment:
I want to hear from you!
What is one thing you learned from this post? How do you envision applying this new knowledge in the real world?
Let me know by Tweeting me at @automationchamp, or find me on LinkedIn.
19 thoughts on “Getting Started with Process Builder – Part 3 (Automatically Clone a Record if it Meets Certain Criteria)”
Eric
Hi Rakesh, love the blog.
Would you mind please explaining the logic behind the
Value: [Opportunity].Name +” + “ formula for the New Opportunity Name?
Could it also make sense to use Value: [Opportunity].Name + Renewal?
I do not understand the use of + and “.
Thanks,
Eric
Sai
What if we keep closedate as “Closed-Won” other than “Prospecting” on our clone opportunity in process builder. What happens then ?
Salesforce is going to create more and more opportunities. If happens how can we stop it ? What are the limitations ?
Thanks for the amazing blog…..Cheers
Kajal
Hi Rakesh,
I didn’t create formula field on Opportunity object, Instead I have done this process following way and it’s working fine.
Under Immediate Action
Field = Close Date
Type = Formula
Value = : [Opportunity].CloseDate + 120.
notsoloud
So it is not truly a clone, but just a creation of a new Opportunity. Same with a Flow, if you want a true clone you’ll have to list out all the fields you want included in Step 7?
Rakesh Gupta
Yes, you are correct. Use SObject collection variable to copy multiple records.
Keri Callison
Thank you so much for this post. I’ve used it to change the record type on a cloned custom object. I was able to change the Record Type field, but how can I make other field “re-set” to blank? I thought it would be $GlobalConstant.Null, but that is incorrect. Thank you for you help!
Rakesh Gupta
You have few options
Sutha
Thank you!
Sutha
This is great!! Only questions – when I try this, the cloned opp does not take the Account name, is there anything I have to do differently to accomplish that?
Rakesh Gupta
Go to the step 7# and also add AccountId field
Sudipta Deb
Rakesh –
I think now we can clone the Opportunity and set the closed date on the cloned opportunity by using formula : [Opportunity].CloseDate + 120. No need to create any additional field in Opportunity object. The above use case I have tried on my developer org without using any additional field and it is working fine now.
Regards,
Sudipta Deb
Rakesh Gupta
Correct but only after Summer’15 release not prior to that.
pkeane2014
Rakesh,
Thank, great articles. Regarding multilevel cloning in process builder, could I use multiple sequential time initiated clones, with a counter field, to stop the sequencing when needed, to effect the result of multilevel cloning in apex?
Thanks
Pete
Brian Newbold
Rakesh, when creating a record can you merge text+field data?
For example in your step 7. is it possible to push a value into a field such as:
” The close date is: [Opportunity].X120_After_RCD__c ”
I tried the usual notation with curly braces like: {!Opportunity.X120_After_RCD__c}
but got an invalid reference error and couldn’t save.
TIA
Brian
Rakesh Gupta
Yes after summer’15 release, you can now update fields using formulas and date functions
http://releasenotes.docs.salesforce.com/en-us/summer15/release-notes/rn_forcecom_process_formulas_update_fields.htm#rn_forcecom_process_formulas_update_fields
Brooks
Thanks, Rakesh! Question on Step 7 – why is the fourth field for “Set Object Variables” a picklist of fields, i.e “Forecast Category”, etc.?
Best.
Brooks
Rakesh Gupta
To set the “Forecast Category”
jagjeet
Good one. I have some doubts around “one time activity” field. Can’t we just avoid it and have an evaluation criteria which says execute only if the stage is changed to “closed won”?
Rakesh Gupta
No because currently ISCHANGED function is not supported by Process builder