+ Start a Discussion
DustinLHDustinLH 

Simple Trigger Help Needed

I know that it can be annoying to see the questions from those of us who are new to this, but any help is appreciated. I am trying to accomplish, what I believe to be a rather simple apex trigger. I have spent over 9 hours today alone trying to locate an example that is similar to mine and have found nothing remotely close.

 

I am trying to accomplish a field update on a custom object triggered by an update on a record from the same object. We have a custom object called deposit accounts. I want the trigger to fire when a deposit account record's field of status is changed to "Accepted". Once that happens, I want the trigger to search all deposit accounts for ones that have a matching name and type field and update the status on those records as well.

 

I thought this would be simple since I am not going cross object and am only trying to update 1 field on multiple records within this same object. I have tried writing this at least 10 times and fail at each corner. I am under a time crunch at work and any help that you provide will be awesome!

Ispita_NavatarIspita_Navatar

Please try the following:-

 

trigger Upd_DepositAcc on DepositAccount__c (before update) {
integer i;
if(Trigger.size == 1)
{
if(Trigger.new[0].status<>Trigger.old[0].status && Trigger.new[0].status=='accepted')
{
 DepositAccount__c[] temp=[Select id, name, status from DepositAccount__c where name=:Trigger.new[0].name and type:Trigger.new[0].type];
  for(i=0;i<temp.size();i++)
  {
   temp[i].status='accepted';
  }
  update temp;
}
}

}

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.