Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications


Using Business Rules to Clear Cell Values

Post Author: Joe D365 |

Microsoft Dynamics CRM Online 2015's Update 1 includes a new enhancement for Business Rules! With this new enhancement, the action "Set field value" now allows users to clear existing values. Previously, clearing the value of a field required custom JavaScript, but now it is out-of-the-box! In today's blog we will delve into this latest enhancement in more detail. Let's get started!

Business Rules provide a great way to achieve the most common and simple validations without requiring custom development. For additional information about Business Rules, you can check out our blog titled Become a Pseudo-Developer with Business Rules in CRM 2013

The screen shot below illustrates where to find the "Clear values" functionality. From within Business Rules in CRM, first select "Set field value".

11

For example, given a set of Conditions, the Action will be to clear the value of the Opportunity Discount (%) field. The Business Rule conditions are as follows:

If the field "Purchase Timeframe" does not contain data or equals either "This Year" or "Unknown" or the Budget field equals "No Committed Budget", the action will clear the value of the Opportunity Discount (%).

The screen shot below illustrates the Business Rule as described above. You will notice that in the Action box, "Set field value" has been selected. The field has been set to "Opportunity Discount (%)" and the "Type" presents you with a drop-down menu that now includes a "Clear" option.

2015-07-24_8-42-11

Remember to Save and Activate in order to test the Business Rule. And that's all it takes. It really is that simple! Please note that this enhancement will work for all data types.

If you would like to learn about other exciting out-of-the-box user interface changes introduced by the Carina update, check out our Top 10 Features blog

Happy CRM'ing!

Joe CRM
By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

One comment on “Using Business Rules to Clear Cell Values”

  1. Hi,
    Is this feature available for on premise as well?
    If so, cud you plz share the build no.

    Thanks
    Pallavi

PowerObjects Recommends