Views:

Scenario Overview

In this scenario the users needed the ability to execute a workflow on an Account record which would generate a comma separated list of Case IDs as a note. See below for an example screenshot.

N52 Formula Manager Solution

The Formula Manager solution works like this,

  • A formula of type 'Process Genie' is created so it can execute as a step within a workflow
  • When it reaches the 'Process Genie' step in the workflow it will execute the formula
  • The formula looks up the list of Case IDs associated to the current account
  • It then creates a note record associated to the account with this list

N52 Formula Manager Steps

The following set of steps outline how to create this Formula

  • Create a new formula of type 'Process Genie'
  • Set the Source Entity to 'Account'
  • Copy & paste the formula below into the formula 
  • Click save & test

Workflow Steps

The following set of steps outline how to create this Formula

  • Create a new workflow named 'Generate Case IDs' on the Account entity
  • Set it to run only 'On Demand'
  • Add a new step to the workflow to call the North52 Process Genie
  • Set the formula shortcode to be the one on the formula you just created, in this case 'KqS'
  • Publish the workflow
  • You are now ready to test

 

Formula

CreateNote('Case IDs', 
           'account',
            [account.accountid],
            FindListValues('incident', 'customerid', [account.accountid], 'ticketnumber', '50', true)
                 )

Wizard - FindListValues

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

Note to find the value for Equals Value, you will need to go to the Source tab > Account 
 

Did you know?

North52's Data Packager helps move configuration data between instances

North52 Data Packager is an add-on for North52 Business Process Activities which enables you to easily move data from one instance to another.  Users simply select the records they would like to package up and North52 Data Packager adds the data to a data package sheet, ready for export. Moving the records to another instance requires the package solution to be imported and ‘unpacked’ on the target instance.

North52 Data Packager is ideal for:

  • Moving Dynamics configuration records
  • Copying Dynamics Portal records
  • Distributing demonstration data

Learn more about the North52 Data Packager