You need to sign in to do that
Don't have an account?
Visual Flow help
Hello, I am new to Visual Workflows and trying to develop a flow that will look at the Stage & Type field on all the Opportunities associated with an Account and update a field on the Account record based on the following.
- If at least one Opportunity has an Approved stage, update the Account field with Approved - Active
- If the stage of every Opportunity is Pending, update the Account with Pending
- If the stage of every Opportunity is Decline, update the Account field with Declined
- If the stage of every Opportunity is Approved-Not Active, update the Account field with Approved - Not Active
Flow Diagram
Fast Lookup. Query all Opportunities with a specific value in the Type field. Assign the records to GetOppID var along with AccountID & StageName
Decision logic for an Approved Opportunity
Decision logic for a Declined Opportunity
Update the Account based on the Approved Decision. The other update modules a built in the same fashion.
Any & all tips or insights are appreciated!
Solution 1:
If you can change the relation between your Accounts and Opportunities to master-child. Following is what you can do:
Solution 2:
In case, you cannot change the relation to Master-Child, I assume, you would be calling the Flow from Process Builder on every stage change of Opportunity. In that case, following are the changes you would need to incorporate in your flow:
Hope this helps. If so, please mark as answer.
Cheers!!
Gaurav