Select Page

Business Rules Example #201 – Create Opportunity from Account using Quick Button

Oct 23, 2018 | Business Rule Example

A new knowledge base article has been published on our support portal.

Scenario Overview

In this example, we will set up a Quick Button on the Account entity. On clicking this button, North52 will open up a new Opportunity entity with 3 fields filled out. 

These fields will be 

  1. Description – We will set the Opportunity description field to New opportunity plus the date/time the Quick button was clicked. 
  2. Purchase Process – We will set this to Committee 
  3. Potential Customer – We will set this to the Account record where the button was clicked. 

N52 Formula Manager Steps

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

  • Create a new formula, setting the following values in the Formula Guide
    • Source Entity set to Account 
    • Set Formula Type to Clientside – Calculation
    • Select the Decision Table editor
  • Under the Register tab for Name , type New Opportunity with Account Details
  • There are no Conditions for this formula so right-click in column A and select Delete > Delete Column
  • Click cell A4, and click the + button to open the editor for this cell
  • Copy and paste the formula provided below 
  • Close the cell editor by clicking the X button in the top right of the cell editor
  • Click Save
  • Take a note of the Formula Short Code in the header of the Formula form

 

OpenEntityForm('opportunity',
  'null',
  SetAttribute('description', 'New Opportunity ' + utcdatetime()),
  SetAttribute('purchaseprocess', 1),
  Setattribute('customerid', [account.accountid]),
  Setattribute('customeridname', [account.name]),
  Setattribute('customeridtype', 'account')
)

Note: If your Opportunity form doesn’t use the composite Customer field you can use the Account lookup field instead using this formula:

OpenEntityForm('opportunity',
  'null',
  SetAttribute('description', 'New Opportunity ' + utcdatetime()),
  SetAttribute('purchaseprocess', 1),
  Setattribute('parentaccountid', [account.accountid]),
  Setattribute('parentaccountidname', [account.name])
)

 

View this article in full on our support portal