There are times when you need to display data from a related entity on a form without the overhead of replicating the information across entities. Quick View forms are a good way to do this if you are pulling multiple fields from the entity and displaying them in one column. To learn more on Quick View Forms, check out our previous post: Exploring the Quick View Forms in CRM 2013. If you need the flexibility to show fields in multiple columns or if you only need one field, calculated fields may be the way to go.

calculated fields

In this blog, we will show you how to use calculated fields to display discrete data from a related entity. To do this we will use the following scenario. Let’s say I need to display a Company’s Credit Limit on an Opportunity record. We can do this by adding a calculated field to the Opportunity Entity and then adding that to the Opportunity form. Let’s see it in action.

Step 1 – Create the Calculated field

1. Navigate to Settings > Customizations > Customize the System.

2. Expand the Opportunity entity and select Fields.

3. Click the New button.

calculated fields

4. Add a Display Name and Description for the new field.

5. Select Calculated as the Field Type.

calculated fields

Note: We are using the Currency Data Type for this field to ensure that the value is formatted correctly when we add it to the form.

6. Select the Edit button to open the Field Definition Editor.

calculated fields

7. Next, we will want to add an Action by clicking the Add Action button.

calculated fields

8. Click into the edit control and select parentaccountid from the list.

calculated fields

9. Type a “.” after parentaccountid and select Credit Limit from the dropdown list.

Note: Adding the “.” after any lookup field will allow you to use related entity fields in your action step.

calculated fields

10. Select the Check button to save your action.

calculated fields

11. Click the Save a Close button on the Field Definition Editor to commit your changes

calculated fields

12. Select Save and Close on the New Field from to update the system Schema

calculated fields

Step 2 – Add the Calculated field to the Opportunity Form

1. Open the Opportunity Form where you would like to display Credit Limit and navigate to the appropriate section.

2. Select the Credit Limit field from the Field Explorer and add it to the form.

calculated fields

3. Save and Publish your customizations.

4. Once you refresh your browser you will see the Credit Limit displayed on your Opportunity form.

calculated fields

For more info and additional uses of calculated fields, visit the Calculated Fields section of The CRM Book!

Happy Dynamics 365’ing!

Avatar for Joe D365

Joe D365

Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.