Creating Custom Entities in Microsoft Dynamics CRM 4
As most know, you can create a custom entity to fit almost any need using the Dynamics CRM application. I frequently encourage people to think of CRM entities as forms; forms that have fields to capture data and user input for storing information in a database. Of course, entities are much more than that as they can have relationships with other entities, used to make a ‘connection’ between entities, used as picklist option type sets for multiple entities, etc. However, it can be easier for users to envision the possibilities when thinking of an entity as a form that contains fields for data collection. Because it is so easy to create entities in Dynamics CRM 4, systems can quickly get out of control, end up with redundant entities, form fields, etc. Therefore, I encourage you to think about a few things before jumping in and creating the entity. If you put in a little planning up front, as it relates to creating custom entities, it will pay off for you and your users.
I Thought We Had Something Like That
The first thing you want to do when receiving a request for a new custom solution in Dynamics CRM 4 is to review your application and see if you already have something similar. It could be that all you really need to do is add a new tab or some additional fields to an existing entity and that will fit the need. It is almost always better to use existing entities rather than creating new ones as that will generally lend to improved productivity and data retrieval. Users can quickly lose interest in an application if they have to create multiple records of different types that have what appear to be related fields. This can negatively impact user adoption.
Naming Conventions & Access Points in Dynamics CRM 4
Ensure each of the custom entity requests you receive include the name that the user wants. Encourage your users to keep the name simple, 24 characters or less is a good rule of thumb. This will be the name that displays in the navigation menu for those modules you indicate when you create the entity. Also, have the user who requested the entity, identify where they want to see it. Do they want to see it from the sales module, workplace, service, in the Outlook Offline Client, etc. This minimizes guess work and helps to ensure a smoother Microsoft Dynamics CRM implementation.
Obtain all requirements from end users to include sections they want to see on the form with names, tabs with names, where they want attributes (fields) placed, the order, display labels, default values and attribute requirement settings such as searchable, not required, etc. This will allow you to quickly move through the creation once you’ve completed your prep work.
Although users will provide you with the display label for the field/attribute, you will want to come up with attribute names that have a few key elements. My rule of thumb includes; keep it simple and try to apply relevant names that will help others when dealing with ‘back end’ systems like creating reports, resolving issues, etc.
There are some good tools online that will help ensure you have all the information you need to create the custom entity in Dynamics CRM 4 or you can quickly create your own tool using Excel or a similar program. You can also leverage CRM by creating a custom entity for managing end user change requests. This can be valuable for both you and end users.
Dynamics CRM Finishing Touches
Once you have the entity created in Dynamics CRM 4 and the new attributes or fields added to the entity, the form designed and tested, and the entity published for use, you might think you are done. However there are a few other items to think about and address before you deliver the entity to your users. One of those areas is relationships. I encourage you to go through the cascading rules related to your 1:N, N:1, and N:N relationships. I almost always change the existing cascading rules associated with the various activity types like e-mail, task, phone call, etc. to configurable cascading rather than parental and set all values to cascade none. If you do not change this then the owner of activities will change when the custom entity record is re-assigned in Dynamics CRM 4. Additionally, if I create new 1:N, N:1 or N:N relationships, I generally use referential as the cascading type of behavior. This defaults to cascade none and removes links to related records if the record is deleted. Since most organizations want to keep a historical view of the original owner of e-mails, tasks and other related records, I go through the effort to make this change. This adds a little time upfront but it is well worth it.
Default views are created for each custom entity. Here are a few suggestions for making the views more user friendly in Microsoft Dynamics CRM 4.
- Update all system views. This provides consistency and minimizes confusion when users move from one view to another (active, my active, inactive, etc.).
- Understand and set fields important to users for preview, quick find, ‘new entity name’ lookup, etc.
- Set view columns in the preview, quick find, etc. to closely match the other system views.
- Leave the default field values for the find columns in the preview, quick find, etc. or select one or two others. Please note that selecting additional fields can impact performance so take care when making changes.
Updating the various views related to an entity in Dynamics CRM 4 can be tedious and time consuming. However, if you want a richer user experience, you will want to take the time to make the changes needed.
Last but not least, you are now ready to go through your security roles and apply the right set of access and other security related settings to each role. If you follow these basic guidelines when creating custom entities in Microsoft Dynamics CRM 4, you will hopefully find your CRM application easier to manage and more user friendly.
Learn more about Microsoft Dynamics CRM 4.0! Listen to our on demand webinar – ‘Top 5 Reasons More Companies are Switching from Salesforce to Microsoft CRM’ now.