Apex Code Development You need to sign in to do that
Don't have an account?
sagar077 Write an apex trigger for update custom field Details_oF_Product__c (text area datatype) . after insert this events want to use. On the Opportunity object, there is a releted list name as Products (Standard) it will take recor
Write an apex trigger for update custom field Details_oF_Product__c (text area datatype) .
after insert, after update , after delete this events want to use.
On the Opportunity object, there is a releted list name as Products (Standard) it will take record data from there and show on custom fields name as Details_oF_Product__c (text area datatype).
Three fields should be show name as Product Code, List Price, Quantity.
Plz help me in this trigger i am new in trigger.
thanks
The result will show on the custom field that is Details_oF_Product__c (text area datatype)
----------------------------------------
----------------------------------------
Product Code : beds
List Price :200
Quantity : 1
----------------------------------------
----------------------------------------
after insert, after update , after delete this events want to use.
On the Opportunity object, there is a releted list name as Products (Standard) it will take record data from there and show on custom fields name as Details_oF_Product__c (text area datatype).
Three fields should be show name as Product Code, List Price, Quantity.
Plz help me in this trigger i am new in trigger.
thanks
The result will show on the custom field that is Details_oF_Product__c (text area datatype)
----------------------------------------
----------------------------------------
Product Code : beds
List Price :200
Quantity : 1
----------------------------------------
----------------------------------------
Greetings!
Unfortunately,we do not have the exact code as per your requirement.However,here are the steps to create the trigger:
If the field Details_oF_Product__c is on Opportunity and you need to get and store the values from child record.
Please refer the sample code to update the parent record from the Child record.
https://salesforce.stackexchange.com/questions/23338/trigger-to-update-parent-object-value-with-child-value
Kindly let me know if it helps you and close your query by marking it as best answer so that it can help others in the future.
Warm Regards,
Shirisha Pathuri
CODE-
trigger OpportunityProductt on OpportunityLineItem (after insert,after update)
{
Set<Id> oppid = New Set<Id> ();
for(OpportunityLineItem pr :Trigger.New)
{
system.debug('my line'+pr.OpportunityId);
oppid.add(pr.OpportunityId);
}
List <Opportunity> AllOpport = [Select Id ,Details_oF_Product__c, (Select ProductCode , ListPrice , Quantity From OpportunityLineItems) From Opportunity Where Id IN : oppid ];
system.debug('my linee'+ AllOpport);
Set <Opportunity> opUpdate = New Set<Opportunity> ();
for(Opportunity ops:AllOpport)
{
system.debug('my lines'+ ops);
for(OpportunityLineItem OLine:ops.OpportunityLineItems)
{
system.debug('my liness'+ OLine);
if(trigger.isinsert)
{
if(ops.Details_oF_Product__c != null && ops.Details_oF_Product__c.countMatches( 'ProductCode =' + OLine.ProductCode + ',' + 'ListPrice='+ OLine.ListPrice + ',' + 'Quantity='+ OLine.Quantity)==0)
{
ops.Details_oF_Product__c += '\n' + 'ProductCode =' + OLine.ProductCode + ',' + 'ListPrice='+ OLine.ListPrice + ',' + 'Quantity='+ OLine.Quantity +'\n';
}
else
{
ops.Details_oF_Product__c = 'ProductCode =' + OLine.ProductCode + ',' + 'ListPrice='+ OLine.ListPrice + ',' + 'Quantity='+ OLine.Quantity ;
}
}
if(trigger.isupdate){
ops.Details_oF_Product__c ='';
if(ops.Details_oF_Product__c != null && ops.Details_oF_Product__c.countMatches( 'ProductCode =' + OLine.ProductCode + ',' + 'ListPrice='+ OLine.ListPrice + ',' + 'Quantity='+ OLine.Quantity)==0)
{
ops.Details_oF_Product__c += '\n' + 'ProductCode =' + OLine.ProductCode + ',' + 'ListPrice='+ OLine.ListPrice + ',' + 'Quantity='+ OLine.Quantity +'\n';
}
else
{
ops.Details_oF_Product__c = 'ProductCode =' + OLine.ProductCode + ',' + 'ListPrice='+ OLine.ListPrice + ',' + 'Quantity='+ OLine.Quantity ;
}
}
}
Update ops;
}
}