Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
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.
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.
1. Navigate to Settings > Customizations > Customize the System.
2. Expand the Opportunity entity and select Fields.
4. Add a Display Name and Description for the new field.
5. Select Calculated as the Field Type.
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.
7. Next, we will want to add an Action by clicking the Add Action button.
8. Click into the edit control and select parentaccountid from the list.
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.
10. Select the Check button to save your action.
11. Click the Save a Close button on the Field Definition Editor to commit your changes
12. Select Save and Close on the New Field from to update the system Schema
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.
3. Save and Publish your customizations.
4. Once you refresh your browser you will see the Credit Limit displayed on your Opportunity form.
For more info and additional uses of calculated fields, visit the Calculated Fields section of The CRM Book!
Happy Dynamics 365’ing!
Business Applications communities