Counting Child records on Parent record form

(0) Share

Report

Posted on by Shane Brown

190

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

All responses (2)

Answers (2)

Verified answer

Gopalan Bhuvanesh 11,401 on at

Like (1)

Report

RE: Counting Child records on Parent record form

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]
Verified answer

M.Azwar Alam on at

Like (1)

Report

RE: Counting Child records on Parent record form

Hi,

Check for rollup field

Mark answer as verified