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!
Azamba Launches EZ Notes: A Smarter, Simpler Way to Take and Manage Notes in Dynamics 365 CRM
Chicago, IL – [March 19th, 2025] - Are messy, disorganized notes wasting your team’s time and leaving critical details lost in the shuffle? Do you spend more time searching for information than acting on it? EZ Notes is here to end the frustration and take the chaos...
Powerful New Updates to Accelerate Sales for Microsoft Dynamics 365 CRM Users
Chicago, IL – [March 5th, 2025] – Azamba is excited to announce the release of EZ Buttons 3.1. This powerful CRM Add-On for Microsoft Dynamics 365 simplifies tasks and makes CRM a breeze to use. With this CRM Add-On, you will work faster and smarter with less...
Azamba releases EZ Buttons 3.0!
Chicago, IL – [November 20th] - We are thrilled to bring you EZ Buttons 3.0, a game-changing update packed with powerful tools to streamline your sales process and help you get more done, faster. With EZ Buttons, turn time-consuming, multi-step tasks into quick,...
Microsoft Dynamics 365 Business Central + CRM Integration Demo | Dynamics Deep Dive Series
In This Demo You Will Learn To: Personalize your CRM to focus on the data that matters most. Create custom dashboards to track critical metrics efficiently. Use data views to help your team make smarter, faster decisions. Simplify Your Sales Process with the Business...
How to Track Your Goals and Metrics in Microsoft Dynamics 365 CRM – Dynamics Deep Dive Series
In the fast-paced world of sales, efficiency and clarity in managing goals and activities are extremely important. Microsoft Dynamics 365 CRM is a transformative solution for sales teams looking to enhance productivity and smash their sales targets. Join experts Peter...
Why MSP’s Should add CRM to their Solution Portfolios
We’re entering a new era in CRM. All the old reasons for customers buying CRM are still valid. But the advent of AI is making the case for renewed interest in CRM. To modify an adage, “If it’s interesting to my customers, then it is fascinating to me!”. AI is...
Boost Your MSP Earnings with Strategic Partnerships
Time is money, we’ve been told since childhood. The idea is that people should focus their attention on the things that bring value to them, and avoid the things that don’t. Since time is a precious resource, it makes sense to try and maximize its utility as it’s the...
CRM Launch in 5 Weeks – Get Results Fast!
CRM is becoming a must-have tool for businesses to stay competitive. But the process of setting it up often wastes time and resources without getting the expected results. To solve this, we've created an approach that makes successful CRM easier to achieve than ever....
How Most CRM Projects Fail & Yours Won’t | CRM Strategy
Did you know that, according to a Gartner study, between 40 to 70% of CRM implementations fail? If you're a small or medium-sized business, this can seriously impact your budget, and you could lose out on profitable opportunities. CRM can be a game-changer for your...
Do This to Avoid Wasting Time and Money With Your CRM
CRM Strategy: The Key to Avoiding a Costly Mistake CRM can either be a game-changing investment for your business or a massive waste of time and money. The difference depends entirely on your approach. Like many businesses, you want to boost sales and increase...
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:

Azamba Launches EZ Notes: A Smarter, Simpler Way to Take and Manage Notes in Dynamics 365 CRM
Chicago, IL – [March 19th, 2025] - Are messy, disorganized notes wasting your team’s time and leaving critical details lost in the shuffle? Do you spend more time searching for information than acting on it? EZ Notes is here to end the frustration and take the chaos...

Powerful New Updates to Accelerate Sales for Microsoft Dynamics 365 CRM Users
Chicago, IL – [March 5th, 2025] – Azamba is excited to announce the release of EZ Buttons 3.1. This powerful CRM Add-On for Microsoft Dynamics 365 simplifies tasks and makes CRM a breeze to use. With this CRM Add-On, you will work faster and smarter with less...

Azamba releases EZ Buttons 3.0!
Chicago, IL – [November 20th] - We are thrilled to bring you EZ Buttons 3.0, a game-changing update packed with powerful tools to streamline your sales process and help you get more done, faster. With EZ Buttons, turn time-consuming, multi-step tasks into quick,...