You need to sign in to do that
Don't have an account?
Zoren Domingo
Update a field in opportunity after adding a particular products
Can anyone help me on these? I'm trying to update a field in opportunity after I add a products and also when I remove it.
trigger AdworksTriggerForCampaignScoreCard on Opportunity (after update) {
List<OpportunityLineItem> relatedOppLI = [SELECT Id,Product2.Name FROM OpportunityLineItem
WHERE OpportunityId IN :Trigger.New];
List<Opportunity> relatedOpps = [SELECT Id,Name,Campaign_Score_Card__c FROM Opportunity];
List<Opportunity> oppsToUpdate = new List<Opportunity>();
for(OpportunityLineItem oppLI : relatedOppLI) {
for(Opportunity opp : relatedOpps){
if(Trigger.isUpdate){
if(oppLI.Product2.Name == 'Addressable')
{
opp.Campaign_Score_Card__c = true;
oppsToUpdate.add(opp);
}
}
}
}
update oppsToUpdate;
}
trigger AdworksTriggerForCampaignScoreCard on Opportunity (after update) {
List<OpportunityLineItem> relatedOppLI = [SELECT Id,Product2.Name FROM OpportunityLineItem
WHERE OpportunityId IN :Trigger.New];
List<Opportunity> relatedOpps = [SELECT Id,Name,Campaign_Score_Card__c FROM Opportunity];
List<Opportunity> oppsToUpdate = new List<Opportunity>();
for(OpportunityLineItem oppLI : relatedOppLI) {
for(Opportunity opp : relatedOpps){
if(Trigger.isUpdate){
if(oppLI.Product2.Name == 'Addressable')
{
opp.Campaign_Score_Card__c = true;
oppsToUpdate.add(opp);
}
}
}
}
update oppsToUpdate;
}
Thanks Raj for your response, actually I already found another way to do this, but I will also try this.
I let you know once I test it. appreciate your help.