You need to sign in to do that
Don't have an account?
Alexski
Field that counts records from another object
I've built a custom Courses object. The Courses object has a Course Registration Number field (CRN).
I also have a CRN field in my Leads object. .
I would like to show the count of related Leads as a field in the Courses object.
The syntax would be something like this:
SELECT COUNT('crn') from Leads where Leads.crn = Courses.crn AND Leads.type="max-exceeded"
Can I do this through a formula field? How? If not, is there another way to do it.
It can't be done with a Formula field, but if the 2 objects have a Master-Deatil relationship you can create a Rollup Summary field.