29 Mar’17

Dynamics 365, EnterpriseEditable Grids in Dynamics 365

Introduction:

Editable Grid is a new feature introduced Out-Of-The-Box with D365 to ease of most common necessity of editing records from the grid itself.

Up until now, you had to explicitly open a record and then update the changes. With Editable Grids,

You can enable Editable Grid at the entity level so that all Entity Views are converted to Editable Grids or also on a specific form where subgrid is used.

Enable Editable Grid on the Entity

  1. Currently, this is how your default read-only grid looks:
  2. Navigate to your entity in the Default Solution (Settings > Customization > Customize The System > Default Solution > Entity) on which you want to enable Editable Grid.
  3. Then select the Controls tab on the entity as shown below:
  4. The click on Add Control… hyperlink as mentioned below:
  5. Once you see the window as below, select Editable Grid and click on Add.
  6. Once this has been enabled for the entity, you can make the change in the Control section as shown below:
  7. I’ve chosen to have Editable Grid for Web, Phone and Tablet as well.

  8. Save and Publish the entity changes.
  9. At this point, the Grid has been enabled on the Entity level.

Enable Editable Grid on the Form

  1. Now, Editable Grid has been enabled for that entity. You can go to your form where you already are using this entity’s subgrid on its form. Open the Form Editor of that form.
  2. Double click on the Grid to show it’s properties. Navigate to Controls tab:
  3. Now, click on the Add Control similar to the step shown to enable Editable Grid on the Entity level.
  4. Make sure the options are selected to use Editable Grid and click OK.
  5. Save and Publish changes made to the form and refresh the form to see the change.
  6. You can now see the subgrid used has changed:

Use Editable Grid

You can quickly hover over the column and record value and change it easily.

Also, fields that are read only, like System Fields will be shown representing a lock indicating that they can’t be edited.

These are some of the basic uses of Editable Grid. More information is provided by Microsoft on their official documentation here: https://msdn.microsoft.com/en-us/library/mt788312.aspx.

Written by

Priyesh Wagh

Sr. Software Developer

Leave a Reply

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

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Reading more then 10K records in D3FOE OData API

    11 July’ 2018

    Introduction: We all know Dynamics 365 Finance and Operations has limitation of 10K records to be fetched at a time usi...

    Read more
  • Paging in D365 Customer Engagement v9.0

    10 July’ 2018

    Introduction: The Xrm.retrieveMultipleRecords method is used to retrieve a collection of records in Dynamics 365 Custom...

    Read more
  • Set up Dynamics 365 connection in Microsoft Social Engagement

    10 July’ 2018

    Introduction: This blog explains how to Set up Dynamics 365 connection in Microsoft Social Engagement. Steps to be follo...

    Read more
  • Voice of the Customer failed to install

    10 July’ 2018

    Introduction: Many people face issues in installing Voice of Customer solution on v9 environment and trying repeatedly ...

    Read more
  • Scribe Insight AX as a Web Service Find Block issue

    10 July’ 2018

    Introduction: If we need to look up for any value from AX then we do it by using a Find Block in Scribe Insight Eg: Basi...

    Read more