Scenario Overview

In this scenario we needed the ability to create and open an appointment directly from a lead in CRM using a North52 Quick Button on the form. The screenshot below shows how this button would appear on the lead form.


N52 Formula Manager Solution

The Formula Manager solution works like this,

  • A formula of type 'ClientSide - Calculation' is created to perform the desired action
  • A North52 Quick Button is placed on the Lead form **
  • When the button is clicked the formula will execute
  • After execution the Quick Button will open the newly created appointment record

** Instructions on how to add the button to the form are at this link.


N52 Formula Manager Steps


The following set of steps outline how to create this Formula

  • Create a new formula of type 'ClientSide Calculation'
  • Set the Source Entity to 'Lead'
  • Set the Mode to 'Client Side'
  • Copy & paste the formula below into the formula 
  • Click save & test


Smartflow( SetVar('Create_Child_record' , 
            SetAttribute('activitytypecode', '4201'),
            SetAttribute('description', 'Reminder Meeting with Client'),
            SetAttributeLookup('regardingobjectid', 'lead' ,[lead.leadid]),
            SetAttribute('scheduledstart', AddHours(UtcDateTime(),1)),
            SetAttribute('scheduledend', AddHours(UtcDateTime(),2)),
            SetAttribute('subject', 'Follow up on Sales Lead!'),
            SetAttributePartyList('requiredattendees', 'systemuser',WhoAmI()))), 

    OpenEntityForm('appointment', GetVar('Create_Child_record'))

Quick Button

Please see article  at this link for instructions on how to set up the quick button which will trigger this formula. 


Wizard - AddHours

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

Note you will need to type into Input Date the formula UtcDateTime() 



Did you know?

You can create customized buttons to trigger complex business rules

North52's Decision Suite has functionality that we call Quick Buttons that allows you to place buttons on a form which when clicked will trigger a North52 Formula.  The business rule logic could be as simple as triggering a workflow or a much more complex process which involves many actions - the full power of the North52 business rules engine for Dynamics 365 can be used. 

The button's themselves can be subject to business rules, that show/hide, activate/deactivate or and/or change labels. This is configured using Decision Tables allowing complex decision logic to drive the button options that are presented to users.

Learn more about Quick Buttons