Views:

Scenario Overview

In this scenario we want users to be able to quickly seen how many of an Accounts Contacts have their Credit on Hold. 

We will use North52 to set a Label Section of the Accounts form. We will set this label to be a sum of how many Contacts have their Credit on Hold (highlighted below) 

North52 Decision Suite Solution

The North52 Decision Suite solution works like this,

  • We create a formula that triggers on the load  event of the Account form
  • The formula counts up all the Contacts whose Credit is on Hold. 
  • The Formula then sets the Contact Information section of the Account form to this number. 


North52 Decision Suite Steps

The following set of steps assumes you are just using the out of the box Dynamics 365 setup. But its easy to enhance if you have extra fields \ requirements.

  • Create a new formula of type 'ClientSide - Perform Action'
  • Set the Mode is set to 'Client Side'
  • Set the Event field to 'Create & Update'
  • Set the Source Entity to 'Account'
  • Set the Source Property to '*** Account Events *** > OnLoad'
  • Copy and paste the formula below into the Formula Editor
  • Click Save
  • You are ready to test.

Formula 

 

Smartflow(

  SetVar('ContactOnHoldAccount',
          FindCount('contact',
                      SetFindAnd('parentcustomerid','creditonhold' ),
                      SetFindAnd([account.accountid],1),
                      'accountid',
                      '0',
                      'true')),

  SetLabelSection('SUMMARY_TAB.CONTACTS INFORMATION',
                   StringFormat('Contacts on Credit Hold {0}', GetVar('ContactOnHoldAccount')))

)

 

Wizard - SetLabelSection()

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

 

Did you know?

You can easily copy/clone test data in TestShield

Once you have set up test data with TestShield it is easy to create a copy/clone and make changes. It is centrally stored so that all users creating tests can use the test data in their tests. This approach dramatically reduces the time it takes to create tests, enabling teams to deliver Dynamics 365 projects faster and at less cost.

Learn more about TestShield

Keywords: Smartflow, SetLabelSection, FindCount, StringFormat, GetVar, SmartFlow, SetVar, Formula Manager