Count Of Contacts

-
trigger CountOfContact on Contact (after insert, after update, after delete) {
    
    list<account> acc=[select id, number__c, (select id, accountid from contacts) from Account];
    list<account> act=new list<account>();
    for(account aa:acc){
        aa.number__c = aa.contacts.size();
        act.add(aa);
    }
    update act;
}


























Comments

Post a Comment

Popular posts from this blog

Page Layouts

-
1. What is PageLayout? A: Pagelayout controls which fields will be displays in which order they will displayed ,which formate that field should be displayed. 2.How many pageLayouts can be assigned to a profile on a object? A: For every profile only one pagelayout is define. 3. What we can controll using pageLayout? A:Fields. 4. How to add Custom button on the PageLayout? A: Drag and drop 5. How to add Custom button relateed list in the pageLayout? A: 6. Find out what type of access is provided on the field when we have following combination             Field Level Security           Page Layout                    output?       Visable   Read     Required     Visable   Read   Required  1.     Ok         No            No                No       No        No 2.     Ok         No            No                 Ok       No      No 3.     Ok         No            NO                Ok       OK     No 4.     Ok          No           NO                OK      No       OK
Read more

SOQL Scenario-1

-
Image
Fetch the Name Fields from Account Object public class SoqlQuery1 {     public List<Account> acc{set;get;}     public SoqlQuery1(){         acc=[select id, name from Account];     } } <apex:page controller="SoqlQuery1" >     <apex:form >     <apex:pageBlock >         <apex:pageBlockSection >             <apex:pageBlockTable value="{!acc}" var="a">                     <apex:column headerValue="Name" value="{!a.name}" />                 </apex:pageBlockTable>             </apex:pageBlockSection>         </apex:pageBlock>     </apex:form> </apex:page>
Read more