Lesson: 20 | Update the Field Number Of Contacts

User Story

Create a program that updates the field Number_of_Contacts__c

The field Number of Contacts must show the number of the Contacts each Account has

Hint: Create a field (Number_of_Contacts__c ) with Number data type

Code

public static void UpdateNumberofContacts(){
        
        List<Account> acList = [SELECT Id, (SELECT Id FROM Contacts), Number_of_Contacts__c FROM Account WHERE Id  IN (SELECT AccountId FROM Contact)];
        
        
        for(Account ac : acList){
            
            ac.Number_of_Contacts__c=ac.Contacts.size();
        }
        
        update acList;
        
        
    }

Prev You need to login to have access to the quizzes. Next

Mastered by 47 users.

Apex Intermediate

A. Apex DML Operations (8 lessons)

B. Apex Classes (17 lessons)

C. Apex Triggers (9 lessons)

D. Apex Exceptions (11 lessons)

E. Asynchronous Apex (6 lessons)

F. SOSL (10 lessons)

G. Testing Apex (9 lessons)

H. Apex Fast Recap (142 lessons)

I. Build Apex Coding Skills (64 lessons)

You need to complete all the quizzes before certification.

Go to top

Lesson: 20 | Update the Field Number Of Contacts

User Story

Expected Outcome

Code

Video

Apex Intermediate

Login to your account

Lesson: 20 | Update the Field Number Of Contacts

User Story

Apex Intermediate