web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Counting Child records...
Microsoft Dynamics CRM (Archived)

Counting Child records on Parent record form

(0) ShareShare
ReportReport
Posted on by Shane Brown 190

Hi

Is there a way to display in a number field the 'Count' of contacts on the Accounts form?

I would require a field on the Accounts form called 'Contacts UK Count' for example that would look at the contacts of that Account and if the Country = UK then it would add/subtract on that field every time the form is opened.

Is it possible through calculated fields, business rules or would it have to be a plugin?

Thanks

*This post is locked for comments

  • Verified answer
    M.Azwar Alam Profile Picture
    M.Azwar Alam on at

    Hi,

    Check for  rollup field

    Mark answer as verified

  • Verified answer
    Gopalan Bhuvanesh Profile Picture
    Gopalan Bhuvanesh 11,401 on at

    Hi

    You can achieve this using a Rollup field (Count aggregate function).

    Please refer the example in the following:

    [View:https://technet.microsoft.com/en-us/library/dn832162.aspx:750:50]

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans