Editable Grids in Dynamics CRM

Discussion in 'Microsoft Dynamics 365' started by bsdinsight, Nov 4, 2016.

  1. bsdinsight

    bsdinsight Well-Known Member

    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
    dynamics_crm_9.png

    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

    Picture21-1024x660.png

    In the “Add Control” dialog click Editable Grid
    Picture31-1024x660.png

    Click Add to add an instance of the Editable Grid.
    Picture41-1024x660.png

    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-1024x660.png

    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-1024x660.png

    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-1024x660.png

    Click OK to return to the Controls tab

    Picture9-1024x660.png

    Finally click Save…
    Picture10-1024x660.png

    …and Publish to save and publish the changes to the entity
    Picture111-1024x660.png
     
  2. Loading...

    Similar Threads Forum Date
    Microsoft Dynamics CRM 2013: Adding row colours to sub-grids dynamically based on value in cells Microsoft Dynamics 365 Nov 29, 2014

  3. bsdinsight

    bsdinsight Well-Known Member

    Example
    To test the Editable Grid control navigate to Sales > Accounts and select the view My Active Accounts
    Picture13-1024x660.png

    Make edits in the grid, eg. change the “Main Phone” number for one of the records in the grid
    Picture14-1024x660.png

    Picture15-1024x660.png

    We can also apply grouping, eg group the grid by the field “Address 1: City”
    Picture16-1024x660.png

    Picture17-1024x660.png

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

    Picture18-1024x660.png

    Picture19-1024x660.png

    Picture20-1024x660.png
    Picture211-1024x660.png

    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.
     
  4. bsdinsight

    bsdinsight Well-Known Member

    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-1024x584.png

    a2-1024x551.png
     

Share This Page