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