Lesson: 40 | UpdateAccountBillingAddress

Create a trigger that updates the billing address of an account to the mailing address of its related contact, whenever a contact's mailing address is updated:

Apex Trigger

trigger UpdateAccountBillingAddress on Contact (after update) {
    Set<Id> accountIds = new Set<Id>();

    for (Contact contact : Trigger.new) {
        if (contact.MailingStreet != Trigger.oldMap.get(contact.Id).MailingStreet ||
            contact.MailingCity != Trigger.oldMap.get(contact.Id).MailingCity ||
            contact.MailingState != Trigger.oldMap.get(contact.Id).MailingState ||
            contact.MailingPostalCode != Trigger.oldMap.get(contact.Id).MailingPostalCode ||
            contact.MailingCountry != Trigger.oldMap.get(contact.Id).MailingCountry) {
            accountIds.add(contact.AccountId);
        }
    }

    List<Account> accounts = [SELECT Id, BillingStreet, BillingCity, BillingState, BillingPostalCode, BillingCountry FROM Account WHERE Id IN :accountIds];
    for (Account account : accounts) {
        for (Contact contact : Trigger.new) {
            if (account.Id == contact.AccountId) {
                account.BillingStreet = contact.MailingStreet;
                account.BillingCity = contact.MailingCity;
                account.BillingState = contact.MailingState;
                account.BillingPostalCode = contact.MailingPostalCode;
                account.BillingCountry = contact.MailingCountry;
            }
        }
    }

    update accounts;
}

Explanation

This trigger first gets the IDs of all accounts whose related contact's mailing address was updated. Then, it retrieves the billing addresses of these accounts and updates them with the corresponding values from the contact's mailing address. Finally, it saves the updated accounts back to the database.

Note that this trigger is defined as an "after update" trigger, which means that it will run after a contact's mailing address has been updated and saved to the database.

Prev You need to login to have access to the quizzes. MARK THIS AS UNDERSTOOD Next

Mastered by 14 users.

Integration Course

A. Apex REST Callouts (13 lessons)

B. GoRest API Integration (6 lessons)

C. REST Web Services (4 lessons)

D. Postman (6 lessons)

E. JSON (2 lessons)

F. SF to SF Integration (1 lessons)

You need to complete all the quizzes before certification.

Go to top

Login to your account

Lesson: 40 | UpdateAccountBillingAddress

Apex Trigger

Integration Course