Scenario Overview

In this business scenario the requirement is for the Business Process Flow to automatically move to different stages depending on the value of a field (Est. Revenue). 

It is required to do this automatically upon saving the Opportunity. The business rules are as follows:

If the estimated budget is greater than 500, move the Business Process Flow to the Propose Stage.
However, if the estimated budget is greater than 1000, move the Business Process Flow to the Develop Stage.

North52 Decision Suite Solution

The North52 Decision Suite solution works like this,

  • A formula of type 'Save - Perform Action' is created on the Opportunity entity
  • When the 'Est. Revenue field' is changed the formula will execute
  • The Business Process Flow will automatically be set to the appropriate stage according to the rules outlined above

North52 Decision Suite Steps

The following set of steps outline how to create this Formula

  • Create a new formula of type 'Save - Perform Action'
  • Set the Mode to 'Server Side'
  • Set the Event to 'Create & Update'
  • Set the Source Entity to 'Opportunity'
  • Set the Source Property to 'Est. Revenue'
  • Copy and paste the formula provided below into the formula editor
  • Click Save


iftrue([opportunity.estimatedvalue] > 500 , 
      if ([opportunity.estimatedvalue] > 1000, 
                             'Opportunity Sales Process',
                            'Opportunity Sales Process',

Wizard - BPSetActiveStageSS

Please see below the wizard you can use to create the BPSetActiveStageSS() function call used in this formula. 



Did you know?

TestShield enables effective test data management

Test data can be easily created from existing records in your system, generating a 'snapshot' of data that represents a valid (or invalid) scenario. This can be easily manipluated and variations created in the Test Data editor to cover valid or invalid test scenarios. Sensitive data can be masked, changed or removed. 

The saved test data is then available to be used when creating your automated tests. It can be reused many times over avoiding repeated effort and maximizing the value of the work done.

Learn more about TestShield