Skip to main content
Topics#ApexDomanda di Dilip Kulkarni
Dilip Kulkarni ha fatto una domanda in #Apex
15 giu 2017, 06:27

trigger to update value

Hi,

I have one field 'total no. of contacts' on account detail page.I want to update that no. whenever contact is deleted.

What will be the the trigger code for the same. 

Kindly help.

Regards.
4 risposte
  1. . Shanky (COFORGE LTD)
    15 giu 2017, 06:57
    Try this One !!! 

    trigger CountContact on Contact(after insert,after delete) {

        Map<Id, List<Contact>> AcctContactList = new Map<Id, List<Contact>>();

        Set<Id> AcctId = new Set<Id>();   

        List<Account> AcctList = new List<Account>();

        List<Contact> ConList = new List<Contact>();

       

        if(trigger.isInsert)  {

            for(Contact Con : trigger.New) {

                if(String.isNotBlank(Con.AccountId)){

                    AcctId.add(Con.AccountId); 

                }  

            } 

        }  

        if(trigger.isDelete) {

            for(Contact Con : trigger.Old) {

                AcctId.add(Con.AccountId);    

            } 

        }          

       

        if(AcctId.size() > 0){

            ConList = [SELECT Id, AccountId FROM Contact WHERE AccountId IN : AcctId];

           

            for(Contact Con : ConList) {

                if(!AcctContactList.containsKey(Con.AccountId)){

                    AcctContactList.put(Con.AccountId, new List<Contact>());

                }

                AcctContactList.get(Con.AccountId).add(Con);     

            }                          

             

            AcctList = [SELECT Contact_Count__c FROM Account WHERE Id IN : AcctId];

            for(Account Acc : AcctList) {

                List<Contact> ContList = new List<Contact>();

                ContList = AcctContactList.get(Acc.Id);

                Acc.Contact_Count__c  = ContList.size();

            }   

                         

            update AcctList;   

        }

    }

    Replace the field api name in account as per your field name .

    Thanks Shanky Munjal
Scrivi una risposta...
0/9000