Previous month:
August 2017
Next month:
August 2018

Editable Grids

Have you discovered the joy of editable grids? This feature was introduced in December of 2016. Editable grid is a custom control in Microsoft Dynamics 365. 

"You can enable editable grids at the entity level to use in the main grid, or at the form level to replace read-only sub-grids (associated grids) with an editable grid." An editable grid is similar to entering data into an Excel spreadsheet and has a number of usability benefits. For instance, users can quickly enter lots of data on different records without needing to open new windows or the editable grid usage can align to business processes that include popping in and out of Microsoft Excel.

Additionally, configuration teams can adjust what a grid looks like based on a set of parameters or data.  Editable grids also support business rules and form scripting so you can apply custom business logic according to your organization's requirements.  

If you want to learn more about how to work with and configure editable grids you can reference the following article  or if you want to see some examples of how editable grids are used this TechNet Article has some interesting use cases.


Don't forget the Glossary and the overwhelming desire to over use status fields

Project Considerations

1) Start with the concept of a glossary and agree on terminology. This seems like such a trivial concept, but has huge ramifications as the systems grow and mature. If everyone agrees on terminology then when fields are named, and option sets defined, the terminology is consistent throughout the system. In fact I know of a company that has a department that defines and manages all of the option set values in every system that they release. This three person team keeps terminology consistent not only in one application, but across all applications created for internal use.  Alignment to the bigger picture and more consistency for the entire company.

2) Now about those status fields. If the status field(s) are option sets then aligning the values to a glossary offers more common understanding.  Each option has a reason and these reasons generally align to business rules. Given the sometimes difficult nature of understanding business rules, common vocabulary can help.

There is a beauty to simplicity.

So how do you simplify complex business rules? Focus the system on the people who are using it and what they care about. Complex business rules are not complex to those who work with them every day. This is their life, so make sure that business rules align to the roles of those who need and care about them.

Eliminate noise: User's do not want to see what they do not care about. Use good definitions of security to allow the system to hide what people don't need to see. This also greatly simplifies the system for their use.

Leverage the power of the out of the box ability to segregate data by business units. Business units are all about segregating data, eliminating noise, speeding up processing and so much more and although they occasionally line up to offices, defining offices is not their primary goal.

Very, very, very carefully consider why and how many status fields you are using and determine a way for the system to manage and keep these status fields updated based on normal human day to day activities.

Understand the personality types of the users in different roles. Are these people task driven? Do they like to complete a list of things to do or are they more organic givers and workers who react to the day? Make sure the system can handle multiple styles of getting work done.

Re-evaluate and Refactor as many times as is necessary to simplify the system.