You need to sign in to do that
Don't have an account?
kjun
Process Builder Creating a new record but wanting to restrict to only 1 record to be created
I've created a process builder flow that creates a child record when a certain stage is selected on the Opportunity record. I want to avoid having multiple child records created if one already exists.
Here is a screenshot of the criteria I used to trigger the action:
Define Criteria Screenshot (https://www.screencast.com/t/Zisb0hjd0SI)
1. [Opportunity].StageName = "Financial Interview"
I believe I need to add another condition to check if a Financial_Interview__c record exists, do not execute this action.
Thank you in advance.
Here is a screenshot of the criteria I used to trigger the action:
Define Criteria Screenshot (https://www.screencast.com/t/Zisb0hjd0SI)
1. [Opportunity].StageName = "Financial Interview"
I believe I need to add another condition to check if a Financial_Interview__c record exists, do not execute this action.
Thank you in advance.
- Use a Flow instead of Process Builder because Flows can search for related records
- Use a Trigger instead of Process Builder becuase Triggers can search for related records
- Change Financial_Interview__c from a Looup to Master-Detail Relationship (if it isn't already) and create a Rollup Summary Field that counts the number of Financial Interviews that are related to each Opportunity. You can then use that a criterion before creating records in the Process Builder.
Thanks,Matt