Editable Grids Is Here


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 (45)

  1. Rune Daub says:

    What about editable grid for subgrids on forms? And will we finally be able to change the editable grid on opportunity products etc?

    1. Niloy says:

      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.

      1. Nishant Rana says:

        No it doesn’t work for subgrid.

      2. Please see todays edit to the blog post

    2. Dave says:

      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?

      1. Rashi says:

        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?

  2. Gafoor says:

    Excellent.. I love this feature.. but.. When it can avaialable for onpremise version.

  3. Thomas Rath says:

    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?

    1. Nishant Rana says:

      It is only for editing existing record for new record we’d need to use same old approach.

  4. Siva says:

    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:)

  5. Mehmet Tirgil says:

    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?

    1. You need a Dynamics 365 instance (preview, trial or production)

      1. Carsten says:

        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.

  6. Patric says:

    Very good feature, does it work for Quote, Order, Sub grid to edit product line items?

  7. Sahan Wijayasekera says:

    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

  8. 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.

  9. Egidijus says:

    Hello,

    Are there any plans to make editable grid available for entities like quote products, opportunity products and such?

    We were really looking forward to this feature, but finding out that it is not available for quote products in particular, crushed out high hopes about using it.

    1. Antony says:

      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?

      1. Pedro says:

        Yes, that’s supported.

  10. Natraj says:

    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)?

  11. Walter Hernandez says:

    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.

    1. try unchecking the grouping option

  12. Nijo Joseph says:

    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 ?

  13. Michael H says:

    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?

  14. Daniel Duffy says:

    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.

    1. Daniel Duffy says:

      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?

    2. Hans Worst says:

      There is an Editable grid solution available for on-premises as well:
      http://www.sonomapartners.com/tools/editablegrid2016

      1. daniel says:

        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.

  15. Michael H says:

    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!

    1. Thomas says:

      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 !

      1. MichaelH says:

        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!

  16. Ravi Bachanagiri says:

    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

  17. daniel says:

    why are editable grids not available for web clients?

  18. 腎臓移植 says:

    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.

  19. Timothy Meredith says:

    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.

  20. Doug Allinger says:

    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.

  21. Super feature, but I’m wondering if it works on CRM for tablet or CRM for Phone as well.

    Thanks!

  22. Vipin says:

    when we try to do use editable grid in dashboard, it is not allowing to select editable grid.

    1. Steven Rasmussen says:

      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?

  23. Ezgi says:

    Quite understandable and easy to apply the steps. Thanks for your great and helpful post Jesper!

  24. Vivek says:

    Please help…
    I have upgraded to CRM 8.2.0.749 (DB 8.2.0.749) on-premises. I have enabled subgrid option on account entity when i go to active accounts view and select a record all the columns are showing lock sign that means it is not editable. I have try contacts and other out of box entities no luck… can please someone help me….

    1. usnr says:

      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)?

  25. GridsFail says:

    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.

  26. Charan says:

    May I know how to set the error/warning notification message and prevent the row update on inline subgrid records save?

Skip to main content