How to Create a Calculated Field on a Form in Microsoft Dynamics 365 for Sales CRM
How to Create a Calculated Field on a Form in Microsoft Dynamics 365 for Sales CRM
Personalize your fields
This week in Microsoft Dynamics Support, we’ll look at how to create a calculated field on a form in Microsoft Dynamics 365 for Sales CRM.
In this example, I’m going to add a field called “anniversary” to my accounts. This field will display the anniversary of our relationship with each company.
You can modify the instructions below to create other calculated fields in other entities.
See below for video and instructions:
Create a calculated field
1.) Go to Settings > Administration > Customization > Customize the System.
2.) Select Entities > Accounts > Fields, then click New to create a calculated field:
3.) Enter a Display Name and Data Type, then set the Field Type to Calculated:
You can also enable field security, enable auditing, add a description, etc. But for this example, we’ll skip those extra steps.
4.) Click Edit to set up the field function, then set the Action to ADDMONTHS(12,createdon)and click the button:
5.) Click Save and Close.
6.) Click Publish all Customizations:
Add a calculated field to a form
1.) Go to the record you want to add a calculated field to and click Form:
2.) Find the field you want to add in the Field Explorer, then drag and drop it into the formwhere you want it to appear:
3.) Click Save and then Publish, then close the form window.
4.) Click F5 to refresh the record sceen.
You should now see your calculated field on the record:
Our OnTrack CRM Success System helps you get the most from your CRM investment with support services including:
- unlimited diagnostic support
- unlimited answers to “How do I …?” questions
- annual system audits
- regular progress calls from a dedicated account manager
- + additional valuable services!
We offer OnTrack in both month-to-month or annual subscriptions, and because we stand behind what we do, we offer a 100% money-back guarantee and you can cancel your plan at any time!
Microsoft Dynamics 365 Old Interface is Going Away – Are You Ready?
What does the new Unified Interface mean for you?
Optimize CRM during a Slowdown with These 6 Tips
It’s time to clean your digital house.
3 Simple CRM Strategies to Optimize Your Remote Office During COVID-19
It’s time to reframe what it means to work together.
How to Assign a Security Role to a User in Microsoft Dynamics 365
Assign or change security roles in 6 simple steps
An Easier Way to Boost CRM Value
Introducing Boosters for Microsoft Dynamics 365 and Sage CRM!
How to Avoid Getting Burned with Your CRM Project
No time to burn.
Azamba Consulting Group Announces Gold Sponsorship of Empower Customer Conference 2020
Founder and president Peter Wolf to speak on thriving in the customer experience economy.
How to Create a Dynamics 365 Follow-up Task from an Outlook Email
Never fail to follow up!
Not Ready for the Microsoft Unified Interface?
Reschedule your Dynamics 365 upgrade.
How to Export a List of Contacts and Email Addresses from Sage CRM
A step-by-step guide.
Dinesh Joseph is a Microsoft Dynamics and Sage CRM technical consultant at Azamba. He trains, supports, and consults for both new and experienced Dynamics 365 and Sage CRM users. He also provides analysis and customization for both systems and their integrations.
His goal is to help his customers run their CRM systems smoothly and efficiently.
Related articles:

Microsoft Dynamics 365 Old Interface is Going Away – Are You Ready?
What does the new Unified Interface mean for you?

How to Create a System View in Microsoft Dynamics 365 for Sales
Create an optimal experience for CRM users!

How to Create a Dynamics 365 Contact Record from Outlook Using the Dynamics 365 App for Outlook
Enter new contacts without disrupting your workflow!