Skip to main content
4 risposte
  1. 31 gen 2023, 07:10

    trigger UpdateContactsOnAccount on Account (before update) {

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

    for (Account acc : Trigger.new) {

    if (acc.Status__c == 'Inactive' && acc.Status__c != Trigger.oldMap.get(acc.Id).Status__c) {

    for (Contact con : [SELECT Id FROM Contact WHERE AccountId = :acc.Id AND IsActive = true]) {

    con.IsActive = false;

    contactsToUpdate.add(con);

    }

    acc.countcontact__c = contactsToUpdate.size();

    }

    }

    if (!contactsToUpdate.isEmpty()) {

    update contactsToUpdate;

    }

    }

     
0/9000