You need to sign in to do that
Don't have an account?
Chitral Chadda
triggr populate field
// Automatically populate a lookup field to the Rival object
on account we have rival_picklist__c and rival__c is a lookup field relation to rival__c custom object
now when we select the picklist value from rival_picklist__c , it should match that name from rival__c object and populate that name in rival__c field
trigger PopulateRival on Account (after insert,after update)
{
set<id> accid = new set<id>();
for( account acc: trigger.new)
{
accid.add(acc.id);
}
list<Rival__c> rvl = [select Name__c ,id from Rival__c];
map<string,id> mapRival = new map<string,id>();
for(Rival__c r :rvl)
{
mapRival.put(r.Name,r.id);
}
list<account> acclist = [select id,Rival_Picklist__c,Rival__c from account where id in: accid];
list<account> updateaccount = new list<account>();
for(account a: acclist)
{
if(mapRival.containsKey(a.Rival_Picklist__c))
{
if(a.Rival__c=null || a.Rival__c!=mapRival(a.Rival_Picklist__c))
{
a.Rival__c = mapRival.get(a.Rival_Picklist__c);
updateaccount.add(a);
}
}
}
update updateaccount;
}
i m able to save the trigger but its not working.
on account we have rival_picklist__c and rival__c is a lookup field relation to rival__c custom object
now when we select the picklist value from rival_picklist__c , it should match that name from rival__c object and populate that name in rival__c field
trigger PopulateRival on Account (after insert,after update)
{
set<id> accid = new set<id>();
for( account acc: trigger.new)
{
accid.add(acc.id);
}
list<Rival__c> rvl = [select Name__c ,id from Rival__c];
map<string,id> mapRival = new map<string,id>();
for(Rival__c r :rvl)
{
mapRival.put(r.Name,r.id);
}
list<account> acclist = [select id,Rival_Picklist__c,Rival__c from account where id in: accid];
list<account> updateaccount = new list<account>();
for(account a: acclist)
{
if(mapRival.containsKey(a.Rival_Picklist__c))
{
if(a.Rival__c=null || a.Rival__c!=mapRival(a.Rival_Picklist__c))
{
a.Rival__c = mapRival.get(a.Rival_Picklist__c);
updateaccount.add(a);
}
}
}
update updateaccount;
}
i m able to save the trigger but its not working.
I am confused with the second condition syntax. Can you please confirm what you are checking in the second condition?