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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s