Find your content:

Search form

You are here

How to write a rollup summary trigger for a lookup relationship

 
Share

Is there anyway to update a rollup summary field with lookup relation ship for a custom object. How can we achieve this using triggers ?


Attribution to: Salesforce developer

Possible Suggestion/Solution #1

https://github.com/abhinavguptas/Salesforce-Lookup-Rollup-Summaries

The above link from Abhinav solves your problem

If you need for more than one object would recommend to try the excellent tool from Andrew

http://andyinthecloud.com/2013/07/07/new-tool-declarative-rollups-for-lookups/

And if you have requirement for only one object ,you can prefer jeff solution as well

http://blog.jeffdouglas.com/2009/07/30/roll-up-summary-fields-with-lookup-relationships-part-1/


Attribution to: Mohith Shrivastava

Possible Suggestion/Solution #2

Here is an example :

  1. Account (Parent Object)
  2. Contact (Child Object).
  3. Contact_Recs__c (Roll up summary field/Custom Field).
  4. accountid (Lookup field).

Code sample:

trigger CountContactsnew on Contact (after insert, after delete, after undelete) {

    List<id> accIdList = new List<id>();
    if(Trigger.isInsert || Trigger.isUndelete){
        For(Contact con1 : Trigger.new){
            accIdList.add(con1.accountid);
        }
    }
    if(Trigger.isDelete){
        For(Contact con1 : Trigger.old){
            accIdList.add(con1.accountid);
        }
    }
    List<Account> accUpdateList = new List<Account>();
    For(Account acc : [SELECT Contact_Recs__c,(SELECT id FROM Contacts) FROM Account WHERE id =: accIdList]){
        acc.Contact_Recs__c = acc.Contacts.size();
        accUpdateList.add(acc);
    }
    try{
        update accUpdateList;
    }Catch(Exception e){
        System.debug('Exception :'+e.getMessage());
    }
}

Attribution to: Prasanta Kumar Pardhi Infosys

Possible Suggestion/Solution #3

I would also recommend this 'no code' Flow solution which I have used in the past: https://salesforceweek.ly/2015/02/how-to-create-roll-up-summaries-using-flow.html


Attribution to: MikeA
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/33650

My Block Status

My Block Content