Scenario Overview

In this scenario the business requirement is that when a user opens an Account record we need to check if the Send Marketing materials field has been set to 'Yes' & if so start a dialog process so the user can send out the marketing materials.

N52 Formula Manager Solution

The Formula Manager solution works like this,

  • The formula executes in the  OnLoad() event of the form 
  • It checks to see if we should start the dialog process
  • If so it starts the process
  • At the end of the process it resets the Send Marketing field so it won't execute the Dialog the next time the record opens

N52 Formula Manager Steps

  • Create a new formula of type 'ClientSide - Perform Action'
  • Set the Event to 'Update'
  • Set the Source Entity to 'Account'
  • Set the Source Property to 'OnLoad'
  • Copy & paste the formula below into the formula description field & click save
  • Click 'N52 Commands' & then choose 'Publish Formula'
  • You are ready to test


if([account.donotsendmm] = false, ExecuteDialog('SendMarketing'), 'NoOp')

Wizard - ExecuteDialog

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

Did you know?

North52 helps you automatically test Dynamics 365 projects

North52's TestShield helps you test Dynamics 365 projects:

  • FASTER - Our no code solution delivers automated CRM project testing faster
  • EASIER - Simple to use point-and-click interface to build simple or complex testing plans
  • SMARTER - Lower your project risk and slash ongoing costs with automated process testing

Learn more about TestShield