Software, Implementation, Training & Support.
One monthly fee.

Build Your Subscription

Let’s face it. With broken New Year’s Resolutions and months of cold weather ahead of us, we need something to warm us up and lift our spirits. Here at Catapult, we’ve found just the thing – the new Editable Grid control in Microsoft Dynamics CRM (Dynamics 365)!

New Year, New Controls: The Editable Grid

As an experienced Senior CRM Developer and Consultant, I can attest that this is a long overdue and highly requested feature for Microsoft Dynamics CRM. While this may seem like a small change in features the Editable Grid touches many areas of the Dynamics CRM product and will prove to have a large impact on how users can now make changes/edits more easily in records.

Editable Grid Example 

In short, the main benefit of the new Editable Grid Control is that it enables users to edit data in a tabular format in Microsoft Dynamics CRM rather than opening each record to make changes, save and repeat. This is a huge improvement in usability. With the help of the Editable Grid, users can accomplish the same task with far fewer clicks – thus minimizing much of the pain and unpleasantness associated with manually updating records.

Having said that, there are still a few kinks that need to be ironed out. For example, the Editable Grid lacks the option to create a new line inside of the grid. Users will still need to launch a new form and thus open a dialog box to create a new record. We can hope this is resolved as this feature evolves (*wink* to developers working on the Dynamics CRM platform at the Microsoft mothership headquarters *wink*).
 
Like What You've Read? Subscribe to Our Newsletter!
 
While the Editable Grid for Microsoft Dynamics CRM/Microsoft Dynamics 365 provides fantastic functionality the release documentation is a little light when it comes to providing usage examples. Consequently I wanted to provide you with step-by-step instructions, not only for enabling and setting up the grid, but also for handling an OnChange event for a cell. Here it goes:

How to configure the Editable Grid:

1. Select the entity for which you want to enable the Editable Grid

2. Click “Controls” > “Add Controls

Editable Grid Controls3. Select Editable Grid and click “Add

description editable grid4. Choose which clients can use it. In the below screenshot it is set to only be available for the Web Client.

editable grid add controls

And presto, you’re ready to get started with the Editable Grid in Microsoft Dynamics!

Microsoft Dynamics NAV cloud backup plan

70% of companies fall short when it comes to having a disaster recovery plan. Download this whitepaper to become better prepared.

How to Handle an OnChange Event:

While being able to edit in the grid is very convenient there will be times when you will want to add events (JavaScript) for such things as validation and business logic. Therefore, I’ve also included an explanation of how to use the OnChange event of a cell to update the value of another cell in the same row.

1. Select the entity

2. Select the “Events” tab

3. Under “Event Handlers,” add a JavaScript library by clicking the “(+) Add” Button.

4. You can either paste in new code, or select an existing code library.

Set Properties Editable Grid

Note: While this example uses a sub-grid from a parent entity, you can also you can also add the library and events for individual forms.

4. Add an Event Handler for the field and event. It is important to pass the execution context.

handler properties editable grid

 

Code Sample:

In the below code sample, I use the context to get the control. With the control we have access to the value (cell data value) as well as the method to retrieve the parent (Row).

Editable Grid Code

The Row contains an attribute collection which we are firing the Get method to retrieve the Cell for another field “new_checkintime1”. The idea here is that when the event field changes we are time-stamping the check-in time.

In addition to this the value of another field – “new_attended” – is set to true. This field is a two-option type.

You will notice on your grid that although the data has changed it will remain in an unsaved mode until the user clicks on the save button.

Get Started with the Editable Grid in Dynamics CRM

With the release of the December 2016 Update for Dynamics 365 the editable grid is now available for both Dynamics CRM online and on-premise. You can find the latest here.

Editable Grid Questions?

Have a question about the Editable Grid? Or have you already set-up it up in your Dynamics CRM/Dynamics 365? We’d love to hear about your experience with the Editable Grid feature. Leave a comment below or get in touch with us!

Comments

  1. Jeff

    Daryl,
    Love editable grids. How do I make Read Only the default view for a grid?

  2. I would love to be able to programatically turn off the + button on a grid. There are times when I want to display/edit the data, but don’t want the user adding new data from that specific location.

Leave a Comment

Your email address will not be published. Required fields are marked *

*

Filter:

Archives

Register to recieve the latest ERP & CRM insights