Display total number of contacts associated with an account.

-
In this part, I am going to explain how to calculate the total number of contacts associated with an account object in a very simple way. After calculating the total number of contacts you can display this totals in a field of an account object. 
This trigger works in all scenario after insert, after delete, after Undelete and after update.

Requirement --

 Create a Number type field named NumberOfContact on account object.
Trigger --

 trigger NumberOfContactOnAccount on Contact (after insert,after update,after delete,after undelete) 
{
    set<Id> ids = new set<Id>();
    
    if(Trigger.isInsert)
    {
        for(Contact c : Trigger.new)
        {
            if(c.AccountId != null)
            {
                ids.add(c.AccountId);
            }
        }
    }
    
    if(Trigger.isDelete || Trigger.isUpdate)
    {
        for(Contact c : Trigger.old)
        {
            if(c.AccountId != null)
            {
                ids.add(c.AccountId);
            }
        }
    }
    if(Trigger.isUndelete)
    {
        for(Contact c : Trigger.new)
        {
            if(c.AccountId != null)
            {
                ids.add(c.AccountId);
            }
        }
    }
    
    List<Account> displayList = new List<Account>(); 
    List<Account> acList = [select id,Number_Of_Contact__c,(select id,name from contacts) from account where Id IN: ids];
    
    for(Account a : acList)
    {       
                  
          a.Number_Of_Contact__c = a.contacts.size();
          displayList.add(a);
        
        
    }
    update displayList;

}

Comments

Post a Comment

Popular posts from this blog

Dynamically Add/Delete rows in Visualforce Page

-
Image
Here is a simple example of adding or deleting rows dynamically in a VF page using the concept of Wrapper Class. Controller-- public with sharing class AddNewRows {     public List<ContactWrapper> cwrap {get;set;}     public Contact con {get;set;}     public Integer rowIndex {get;set;}          public AddNewRows(ApexPages.StandardController controller)     {         rowIndex = 0;         cwrap = new List<ContactWrapper>();         con = new Contact();         cwrap.add(new ContactWrapper(con,0));  //call ContactWrapper class //constructor     }          public void addRows()     {         rowIndex += 1;         Contact c = new Contact(); // create new instance of object         cwrap.add(new Contact...
Read more

Process Automation Specialist Superbadge

-
Hi Folks, This superbadge is all about to test one's automation skill using superb automation tools which salesforce provide. So, here i'm going to discuss every problem statements / business requirements of Process Automation Specialist superbadge and convert them into a problem solving flow. I would rather say read twice or thrice unless you are not clear with problem statement /requirement to every challenges of this superbadge, doing so, will give you a clear picture  of problem statement. Challenge-1 : Automate Leads Step-1 :  Validation rule on Lead to verify Country and State field. Lead Country must be either US , USA or United State or it can be blank.  Lead State must be valid 2-digit US state.                Steps-2 : Create Two Queues 1. Rainbow Sales. 2. Assembly System Sales. Create an lead assignment rule and make 2 rules entries and give order accordingly. Based on LeadSource value lead should be a...
Read more

How to show or hide a particular section of Visualforce Page dependent upon picklistfield value

-
Image
In this example, I am going to explain that how to show/hide a particular section of Vf Page that depends on a picklist field value i.e. for a specific picklist value you are showing/hiding a particular part of a VF Page. This can be achieved by using both the Standard Controller and as well as Custom controller functionality. Here I am using Standard Controller functionality. VF Page--- < <apex:page standardController="Contact">   <apex:form id="frm">       <apex:pageBlock >           <apex:pageBlockSection >               <apex:inputField value="{!contact.LeadSource}">                   <apex:actionSupport event="onchange" reRender="frm"/>               </apex:inputField>            </apex:pageBlockSection>      ...
Read more