At present we have\u00a0following capabilities in editable grids:<\/p>\n
- \n
- Inline capability for most of Dynamics 365 fields (which means it\u2019s still does not support all fields but stills it\u2019s an awesome feature!!)<\/li>\n
- Nested grid view (only for phone and tablet client)<\/li>\n
- Grouping and filtering capability.<\/li>\n
- Sorting, Paginate and adjust columns in the grid.<\/li>\n
- Looking filtering<\/li>\n
- Include calculated and rollup fields as read only<\/li>\n
- Enabling\/disable fields based on security role.<\/li>\n<\/ul>\n
So let\u2019s see how we can enable editable grids for different views. Suppose we want to add inline editing capability for account entity views. To enable it we can use following steps:
\n1. Navigate to Settings-> Customizations-> Customize the System.
\n2. Expend Entities node under solution components and select Account entity->Controls-> Add Control\u2026.<\/strong>
\n![\"inlineediting1\"](\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2016\/11\/inlineediting1-300x66.png\")
<\/a>
\n3. Select Editable Grid<\/strong> under Add Control<\/strong> dialog and click on Add<\/strong> button (All other controls only works for phone and tablet)
\n4. Select Web radio button to enable editable grid for CRM web application.
\n5. Click on Save button under solution command bar and then click on Publish to publish our changes.
\n6. Minimize solution and refresh CRM application. We will do some more changes in later steps.
\n7. Navigate to Sales-> Accounts<\/strong> and click on Editable Grid under SHOW AS<\/strong> button on command bar. (You will be able to see this button only after adding Editable Grid under controls)
\n![\"inlineediting2\"](\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2016\/11\/inlineediting2.png\")
<\/a>
\nNow we should be able to edit fields like following
\n![\"inlineediting3\"](\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2016\/11\/inlineediting3-300x152.png\")
<\/a><\/p>\nWe can also apply grouping using Group By drop down like following:
\n![\"inlineediting5\"](\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2016\/11\/inlineediting5-300x111.png\")
<\/a>
\nNow we can do inline editing to columns of the primary entity, related entity field does not support inline editing. Now let\u2019s go to solution again and add lookup filtering capability.
\n8. Navigate back to your solution and click on Add Lookup and now we can configure lookup filtering just like we can do it on entity form. We can also change view that we want to show in lookup window.
\n![\"inlineediting4\"](\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2016\/11\/inlineediting4-300x204.png\")
<\/a><\/p>\nWe can also configure nested grid by editing Nested grid view option but this is available to phone and tablet user only at this point. Save and publish your changes to see result.<\/p>\n","protected":false},"excerpt":{"rendered":"
With the release of Dynamics 365, now we have editable grid available out of the box, so no need to buy any custom add-on for inline editing. We can enable editable grid to views as well as to sub grids. We can add editable grid controls to all the entities which fulfill following condition: All the entities which is customizable… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[402],"tags":[404,406,405,407,408],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2514"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2514"}],"version-history":[{"count":8,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2514\/revisions"}],"predecessor-version":[{"id":2527,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2514\/revisions\/2527"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2514"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2514"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"inlineediting1\"](\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2016\/11\/inlineediting1.png\")
<\/a>