Hey guys, today in this post we are going to learn about How to create roll-up summary trigger for count child records on custom object using Apex trigger in Salesforce.
parentObjTrigger:- Custom Fields & Relationships
Create a custom field on parent Object name as childRollUp__c (Number Type).
childObjTrigger:- Custom Fields & Relationships
Create a lookup relationship field on child Object name as childLookup__c : Lookup(parentObjTrigger).
Real time scenarios:- Write a roll-up summary trigger for count child records on custom parent object.
Create a custom field (Number Type) on parent object, calculate the total number of related child records and put into them.
- Don’t forget to check out:- Trigger on contact to update a account custom field Click Here For More Information
Files we used in this post example:-
| childObjTriggerRollUp.apxt | Apex Class Trigger | It will be fired whenever insert, update and delete a record on child object |
|
Parent Cusotm Object:- parentObjTrigger__c Custom Field :- childRollUp__c
|
Parent Object with Custom Field | Trigger on child object and calculate the total numberof related child records on the parent object. |
|
Child Custom Object:- childObjTrigger__c Custom Field:- childLookup__c >> Lookup(parentObjTrigger) |
Child Object with Field |
childLookup__c : Lookup(parentObjTrigger) field it is help to communicate on parent object. |
You can download file directly from github by click here
Final Output
Other related post that would you like to learn in Salesforce
Step 1:- Apex Class Trigger : childObjTriggerRollUp.apxt
From Developer Console >> File >> New >> Apex Trigger
childObjTriggerRollUp.apxt [Apex Class Trigger]
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 |
trigger childObjTriggerRollUp on childObjTrigger__c (before insert, before update, before delete, after insert, after update, after delete, after undelete) { List<childObjTrigger__c> childObjList = new List<childObjTrigger__c>(); Set<Id> accSetId = new Set<Id>(); if(trigger.isBefore){ system.debug('trigger before#'); }else if(trigger.isAfter){ system.debug('trigger after#'); if(trigger.isDelete){ childObjList = trigger.old; }else{ childObjList = trigger.new; } List<parentObjTrigger__c> updateParent = new List<parentObjTrigger__c>(); for(childObjTrigger__c childObjNewList:childObjList){ if(childObjNewList.childLookup__c != null){ accSetId.add(childObjNewList.childLookup__c); if(trigger.isUpdate){ childObjTrigger__c childObjOld = trigger.oldMap.get(childObjNewList.Id); system.debug('childObjOld ' + childObjOld); if(childObjOld.childLookup__c != childObjNewList.childLookup__c){ accSetId.add(childObjOld.childLookup__c); }else if(childObjOld.childLookup__c == null){ accSetId.add(childObjNewList.childLookup__c); } } } } //system.debug('accSetId ' + accSetId); for(parentObjTrigger__c parentSetObj: [Select Id, Name, childRollUp__c, (Select Id, childLookup__c From childObjTriggers__r ) From parentObjTrigger__c Where Id IN:accSetId]){ List<childObjTrigger__c> childSize = parentSetObj.childObjTriggers__r; parentSetObj.childRollUp__c=childSize.size(); updateParent.add(parentSetObj); } update updateParent; } } |
Further post that would you like to learn in Salesforce
Does rollup summary field fire trigger?
Yes, Changes in rollup summary field can cause trigger to fire. If the record contains a roll-up summary field or is part of a cross-object workflow, performs calculations and updates the roll-up summary field in the parent record. Parent record goes through save procedure.
Can we create roll up summary fields in lookup relationship?
Unfortunately, roll-up summary fields are only available for objects in a Master-Detail relationship and are not available for those that have a Lookup relationship.
How many roll-up summary fields can be created in an object?
In general, first try to set up your reports to make these calculations before requesting a limit increase. Note: While increases can be submitted to Support, the maximum hard-coded limit for roll-up summary fields is 40 per object and cannot be increased above that.
Related Topics | You May Also Like
Trigger to Update the Custom Last Modified Date Field in the Parent Object When the Records in the Child Object is Updated Using Apex Trigger in Salesforce | How to get the last modified date of a custom object in apex trigger
Trigger to update parent records field when child record is updated | update parent field from child using apex trigger
Trigger to update count of child records with custom field of parent object | count of child records on parent for lookup relationship uses of apex trigger in Salesforce
Trigger to check duplicate name to custom object in Salesforce | how to prevent duplicate records based on multiple fields through apex trigger in Salesforce
Apex Trigger on Contact to Create Account Automatically and map to related account Id to Contact Whenever New Contact is Created in Salesforce | trigger to create account automatically whenever contact is created in salesforce
Trigger on contact to update a account custom field | Write a trigger on contact and update the account custom field uses of apex trigger in Salesforce
Apex Trigger to Send a Custom Visualforce Component Email Template when Record is Created on Custom Object in Salesforce | How to send email template through apex trigger
Write Apex Trigger on Account to Count the number of Contact records using Map in Salesforce | Apex trigger on Account to create and count the number of Contact records associated with Account object based on custom field when Account record is created/updated in Salesforce
- Your reaction of the article ▾
Author of w3web.net
Hi, I am a senior software developer and working in MNC company from more than 8 years. I am great fan of technology, configuration, customization & development. Apart of this, I love to write about Blogging in spare time, Working on Mobile & Web application development, Salesforce lightning, Salesforce LWC and Salesforce Integration development in full time. [Read full bio] | | The Sitemap where you can find all published post on w3web.net
great information
good post
You’re a beautiful inspiration. It really helps me in any situation. Where I stuck. Many of my friends told me to comment there post but I stuck what I should comment. Finally I got your post it always help me. Thanks for the lovely post.
Good POst
This very beautiful and good articles and good fact and lovely post
Hi there to every one, for the reason that I am truly eager of reading
this blog’s post to be updated on a regular basis. It includes good material.
Thank You
Amazing article, and I have learnt a lot
Amazing article, and I have learnt a lot
Nice article, and I have learnt a lot
nice