Apex Code Development You need to sign in to do that
Don't have an account?
K_dev Trigger to update Account field
Can anybody check and tweak this trigger according to my requirement.
Create a new read only field on Customer for "Latest Call List" Text 30 (or whatever field length the call list name is). Every time a call list object is added to Person Account, a trigger updates this field with the Call List name(whichever is the latest record).
Call List is Master detail to Person Account.So whenever a new calllist is added immediately latest_Call_List__c field on account must be updated with the call list name.
trigger UpdatenameFieldstoAccount on call_list__c (after insert, after delete, after update)
{
Set<String> accountIds = new Set<String>();
if(Trigger.isDelete)
{
for( Call_List__c calllist : Trigger.old)
{
accountIds.add(calllist.Account__c);
}
}
else
{
for(Call_List__c calllist : Trigger.new)
{
accountIds.add(calllist.Account__c);
}
}
List<Account> accounts = new List<Account>();
for(Account acc : [select latest_Call_List__c, (select Name from Call_List__r order by CreatedDate asc) from Account where Id in :accountIds])
{
acc.latest_Call_List__c = null;
for(Call_List__c calllist : acc.call_List__r)
{
acc.latest_Call_List__c = calllist.Name;
accounts.add(acc);
}
if(accounts.size() > 0)
{
update accounts;
}
}