Partager via

Editable Grids Is Here

  • Article

Editable Grids in Dynamics CRM

What is it

To enrich the CRM user interface for a touch friendly interaction across all mobile clients, we introduced a new set of embedded controls for the CRM Mobile Client Application (aka MoCA) with the Custom Control Infrastructure feature in the last release.

These controls offer both a more intuitive experience for users with mobile platforms (sliders, spinners, etc.) and address certain business needs (Calendar, Youtube player, website preview , etc). See this blog post for more.

The set of these controls are now installed via a CRM Solution during the CRM installation process, and the infrastructure was changed - allowing you to configure these alternative visualizations to your existing fields and subgrids on the Forms, Homepage Grid, and Dashboard as desired.

The Editable Grid control coming with the Dynamics CRM 2016 Fall Release will utilize this capability to extend the functionalities currently available to you in the Homepage Grid and sub-grid contexts.

Editable grids, one of the most highly requested features for Microsoft Dynamics 365, provide rich inline editing in main grids and sub-grids so you can update the information you need with fewer clicks.

Editable grids support:

  • In-grid editing of records at the entity or sub-grid level
  • Web and mobile clients
  • Navigation using a keyboard or mouse
  • Grouping and Sorting (Able to group by/sort by any column on current view)
  • Filtering
  • Moving and resizing columns
  • Pagination
  • Lookup configuration
  • Calculated fields and Rollup fields
  • Business rules
  • Hierarchical view
  • Enabling or disabling of cells based on security role

The Editable Grids control is available for Dynamics CRM Online and Dynamics CRM On-Premises.

How to enable

As mentioned above the Editable Grid is built on CCF (Custom Control Framework), and configuration is per each entity. One configuration applies all form factors (Web, Tablet, Mobile).

Please note - to follow along with the below example you'll need a Dynamics 365 instance (either preview, trial, or production)

To enable the Editable Grid control for the CRM Web Client, you navigate to the Customizations area under Settings and add the Editable Grid control to the entities of your choice.

Steps:

Navigate to Settings > Customizations > Customize the System

Picture1

Click the entity for which you want inline editing (eg. Account), click the Controls tab, and then click Add Controls to display the "Add Control" dialog

Picture2

In the "Add Control" dialog click Editable Grid Picture3Click Add to add an instance of the Editable Grid.
Picture4

In the newly added row for the  Editable Grid control select the Web option

Note

  • The "Microsoft Dynamics 365 Read-only Grid" is the initial default for Web, Phone, and Tablet
  • After adding an Editable Grids control to an entity you will get a new Events tab, for setting events to fire in the grid (see later)

Picture5

Now the Editable Grid is the default control for Web.

If you'd like to see a how you can work with Lookups in the grid too, click Add Lookup under Property to display the "Configure Property Add Lookup" dialog

Picture6

In the "Configure Property Add Lookup" dialog, in the Available Views drop-down, select which view to add the lookup to (eg My Active Accounts) and the lookup column you want added (eg Primary Contact) in the Available Columns drop-down.

Picture8

Click OK to return to the Controls tab

Picture9

Finally click Save...

Picture10

...and Publish to save and publish the changes to the entity

Picture11 Picture12

Example

To test the Editable Grid control navigate to Sales > Accounts and select the view My Active Accounts Picture13

Make edits in the grid, eg. change the "Main Phone" number for one of the records in the grid

Picture14 Picture15

We can also apply grouping, eg group the grid by the field "Address 1: City"

Picture16 Picture17

Finally we can change the "Primary Contact" for one of the records in the grid using the Lookup we added to the control.

Picture18 Picture19 Picture20 Picture21

Supported

  • Editable Grid supports most of data types except:
    • State
    • Customer type field
    • Composite field
    • Partylist
    • Lookup entity related fields
  • Editable Grid respect read-only grid metadata and configurations
  • Editable Grid support the below JavaScript events for home grid and sub-grids:
    • OnRecordSelect
    • OnSave
    • OnChange
  • Editable Grid support the below entity level Business Rules:
    • Show error message
    • Set field value
    • Set business required
    • Set default value
    • Lock or unlock field

I hope you will enjoy this long awaited feature.

 

Edits

November 1st, 2016 on Subgrids

To apply Editable Grids to a subgrid, head for the Form designer, select the subgrid of your choice, click Change Properties, work with the Controls tab as described above

a1 a2

Comments

  • Anonymous
    October 30, 2016
    What about editable grid for subgrids on forms? And will we finally be able to change the editable grid on opportunity products etc?
    • Anonymous
      October 31, 2016
      A great feature : but from the images available, its not clear yet, if we can add relationships! I think editable feature isn't there for sub grids. not sure though.
      • Anonymous
        November 01, 2016
        No it doesn't work for subgrid.
      • Anonymous
        November 01, 2016
        Please see todays edit to the blog post
        • Anonymous
          November 03, 2016
          Thanks Jesper.
    • Anonymous
      November 01, 2016
      That would be also interessting for me. It looks like that editable grid for oppoproduct or invoicedetail Entity isn't working for custom views in current version 1612 (8.2.0.561) (DB 8.2.0.561.. :/Will it came with next preview or is this version the final for dynamics 365?
      • Anonymous
        November 04, 2016
        This is really good feature. But, it is not available currently available for Opportunity Products, Quote Products, Addresses...Is there any plan in near future to provide for these entities as well?
  • Anonymous
    October 31, 2016
    Excellent.. I love this feature.. but.. When it can avaialable for onpremise version.
  • Anonymous
    October 31, 2016
    Really looking forward to this. Do you know if the new feature also supports creation of new records? Or is it only for editing existing records?
    • Anonymous
      November 01, 2016
      It is only for editing existing record for new record we'd need to use same old approach.
  • Anonymous
    October 31, 2016
    Nice feature which we have been looking for a long time.This is a nice usability feature for the end users and reduces lot of customization in implementing for the developers:)
  • Anonymous
    November 01, 2016
    We use Dynamic CRM Online 2016, but i can't see the Editable Grids when i click Add Control. So is there anything else to do see this?
    • Anonymous
      November 01, 2016
      You need a Dynamics 365 instance (preview, trial or production)
      • Anonymous
        December 02, 2016
        Hi, I have the same problem. How may I find out that I have a "real" Dynamics 365 instance? Because we manage our CRM over the Office 365 - Dynamics 365 Console. But this seems not to be the same as "Having a Dynamics 365 instance"...Thank you in advance.
  • Anonymous
    November 02, 2016
    The comment has been removed
  • Anonymous
    November 02, 2016
    Hi, I have been trialling out the editable grid on Dynamics 365, and it is great. A long waited feature finally in CRM. Quick question. Lets say we use the editable grid on a form to edit a 1: N Relationship data. Can we add records via the editable grid? At the moment although we have editable grids enabled and working, when we want to add a record, we have to do that via the form. I have seen this with another 3rd party editable grid solution where we can add new records as well via the editable grid
  • Anonymous
    November 03, 2016
    Great new feature. Worth to notice that it turns off the duplicate detection rules for the entity.Adding the editable grid on account deactivated the four OOB duplicate detection rules on account.
  • Anonymous
    November 04, 2016
    The comment has been removed
    • Anonymous
      November 07, 2016
      As you know guys, Dynamics 365 included the editable grid... And I have a question: working with this, if we have a lookup column to be edited, is it possible to filter in that column the records to be chosen depending on other values of the same record with we are editing?
      • Anonymous
        November 13, 2016
        Yes, that's supported.
  • Anonymous
    November 07, 2016
    Great post Jesper. When you say "As mentioned above the Editable Grid is built on CCF (Custom Control Framework)", are you referring to an internal MS framework or is this available for anyone to download and and extend (like SparkleXRM)?
  • Anonymous
    November 10, 2016
    Nice Feature, but still doesn't work for subgrids. I just activated the control for the Recent Opportunities subgride in Account and it disappears. I just see the lebel of the subgrid.
    • Anonymous
      November 14, 2016
      try unchecking the grouping option
  • Anonymous
    November 21, 2016
    Great!!! One of the most awaited feature ...Is this going to be available for existing CRM 8.1 versions as a patch update ? or when is the 8.2 update releasing for existing instances ?
  • Anonymous
    November 21, 2016
    Looks very promising but we are currently testing CRM 2016 Update 1 (v8.1.0.359) On-prem and editable grids is not an available option under any entity under the Controls tab within Customisation (only get calendar control and timeline control). What exact version is this supported/released on? Is there anything else I need to do to enable the feature?
  • Anonymous
    November 23, 2016
    Why is this not available for on-prem deployments? Is it a timing issue or is there some other reason MS isn't making it available? And if it's timing, and eventually WILL be available for on-prem, WHEN? Why is there no mention of this anywhere? If there is, does anyone know where it can be found? It seems like MS is offering plenty of cool new stuff for ONLY their cloud customers, but leaving their on-prem customers hanging in the wind. If that isn't the case, then were CAN we find details on when the cool new stuff like editable grids/sub-grids will be made available for your on-prem customers too? Not every deployment is a fit for cloud but that shouldn't mean on-prem customers have to take the leftovers. If this is going to be made available for on-prem, I need to plan for it and know when. I don't want to guy deploy some 3rd party solution, then have to undo it if/when MS finally makes this (and other controls I've seen) available to their on-prem customers. Thank you.
    • Anonymous
      November 23, 2016
      To clarify, running latest version on-prem (8.1.0.359) and every control in the system provides only 2 options - phone/tablet. There is no web option listed anywhere to even select a control for on-prem deployment. so if you don't use a phone/tablet client, how exactly is this supported on-prem?
    • Anonymous
      December 14, 2016
      There is an Editable grid solution available for on-premises as well:http://www.sonomapartners.com/tools/editablegrid2016
      • Anonymous
        December 20, 2016
        that's 3rd party - people expect this to work OOB from MS no different for web clients as phone/tablet. i do at least, and I'm sure my expectations aren't that unique. MS is really falling short on this IMHO.
  • Anonymous
    December 16, 2016
    Anyone have an update for this feature to be available for CRM 2016 Update 1 (v8.1.0.359) On-prem?Once again still on have access to the calendar and timeline controls.If anyone has any info it be much appreciated!
    • Anonymous
      December 20, 2016
      Hi,I just intalled the december patch on my OnPremise server and can confirm it works well (version is 8.2.0000.0749).We have the limitation that we cannot use it on a subgrid like Opportunity Products though which is really a pity... I was hoping to bypass the limits we had on the previous InLine Edit default view with this new feature, but that's not possible :(I really hope MS improves on that matter in a later release. Let me know if you find a way !
      • Anonymous
        January 05, 2017
        Thank you for the reply and confirmation. We are currently on 8.1.0.359 and have yet to update with the December patch so to hear it is included in the December patch is good news!
  • Anonymous
    December 19, 2016
    Its a great feature waiting from long time, But the only consern or the thing which I might have missed it that how to edit the grid in the main form . Such as Account (Entity)>> Contacts (Subgrid)Opportunity (Entity)>> State Holders, Sales team, Competitors(Subgrids). For that matter even any custom Subgrid. Any suggestions would be greatly appreciated.Thanks Ravi Bachanagiri
  • Anonymous
    December 20, 2016
    why are editable grids not available for web clients?
  • Anonymous
    January 02, 2017
    Very impressive information. I love it. Editable grids, one of the most highly requested features for Microsoft Dynamics 365, provide rich inline editing in main grids and sub-grids so you can update the information you need with fewer clicks.
  • Anonymous
    January 17, 2017
    Option Sets not showing names, only showing values.Is this normal? Our option sets are only showing raw values when we go to filter them (Ex, 100000001, etc) in the filter button in the inline editing. It's not a lookup reference field, its actually on the same entity. It shows the actual labels in the list but makes filtering with option sets difficult/impossible for end users.
  • Anonymous
    January 19, 2017
    With all this excitement over editable grids, it is extremely disappointing to find that users still can't CREATE new records with this feature, leaving us to still either use other 3rd party products or forcing users to open and close forms.
  • Anonymous
    February 02, 2017
    Super feature, but I'm wondering if it works on CRM for tablet or CRM for Phone as well.Thanks!
  • Anonymous
    February 07, 2017
    when we try to do use editable grid in dashboard, it is not allowing to select editable grid.
    • Anonymous
      March 14, 2017
      I'm seeing the same issue when trying to create an editable grid on a dashboard. Any thoughts? Is this a bug or known limitation?
  • Anonymous
    February 22, 2017
    Quite understandable and easy to apply the steps. Thanks for your great and helpful post Jesper!
  • Anonymous
    March 20, 2017
    The comment has been removed
    • Anonymous
      May 01, 2017
      Having the same issue as Vivek. Can anyone comment on whether edit grid is supposed to work with CRM 8.2.0.749 (Dynamics 365, on-premises)?
  • Anonymous
    May 25, 2017
    Editable Sub-Grids do not work in 365 on-prem. If I pop out the view I can see them just fine, but not within the form.
  • Anonymous
    July 02, 2017
    May I know how to set the error/warning notification message and prevent the row update on inline subgrid records save?