4 respuestas
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;
}
}