Trigger to Count records in self relationship salesforce

Question

I am working on one scenario.

I have an object called "Property_Assignment__c" which has two record types. 1) Primary Property Assignment 2) Secondary Property Assignment Its also having a self lookup relationship and this lookup field "Primary_Assignemnt__c" is available on "Secondary Property Assignment" page layout which is lookup to "Primary Property Assignment". Now if I create any records in "Secondary Property Assignment" record type then I need to count and save in "Number_Of__Dependents" field in "Primary Property Assignment".

How can this problem be solved?

Answer 1

You should only use triggers if you want to count the Secondary Property Assignment entries. When the master-detail relationship is accessible, we can utilise Rollup summary to count the number of Secondary Property Assignment data.

However, you have self-relationship here. As a result, you can create a trigger that counts the number of records.

Hope this helps!

Enroll in our Salesforce Course here to learn more about creating a trigger in Salesforce.

Thanks!