Trigger to update parent object value with child value

Question

In my company we are using Oppotunity standard object and we have created a custom Quote object. The opportunity object is the parent and Quote is the child. How has to be the trigger in order to update the Amount Opportunity value with the Amount Quote Value?

I´m new with Apex and it will be very usefull has some APEX code to do this.

I have reuse some trigger example and it has to be something similar to:

trigger UpdateAmount on Quote__c (after insert) {

    List<Opportunity> parentObjList = new List<Opportunity>();
    List<Id> listIds = new List<Id>();

    for (Quote__c childObj : Trigger.new {
        listIds.add(childObj.Opportunity);
    }

    parentObjList = [SELECT id,Name,(SELECT ID, Total_List_Price__c FROM Quote__r) FROM Opportunity WHERE ID IN :listIds];

    for (Opportunity opp : parentObjList){
        for (Quote__c quote: Opportunity.Quote__r){
            opp.Amount = quote.Total_List_Price__c;
        {
     {

    update parentObjectList;
}

Thanks

Answer 1

Just looking at the code you have there a few things stand out. I haven't tested this but I've added comments which might help you along

trigger UpdateAmount on Quote__c (after insert, after update) { //You want it on update too, right?
  Map<ID, Opportunity> parentOpps = new Map<ID, Opportunity>(); //Making it a map instead of list for easier lookup
  List<Id> listIds = new List<Id>();

  for (Quote__c childObj : Trigger.new {
    listIds.add(childObj.Opportunity);
  }

  //Populate the map. Also make sure you select the field you want to update, amount
  //The child relationship is more likely called Quotes__r (not Quote__r) but check
  //You only need to select the child quotes if you are going to do something for example checking whether the quote in the trigger is the latest
  parentOpps = new Map<Id, Opportunity>([SELECT id, amount Name,(SELECT ID, Total_List_Price__c FROM Quotes__r) FROM Opportunity WHERE ID IN :listIds]);

  for (Quote__c quote: Trigger:new){
     Opportunity myParentOpp = parentOpps.get(quote.Opportunity__c);
     myParentOpp.Amount = quote.Total_List_Price__c;
  }

  update parentOpps.values();
}

Answer 2

Late to the party, but...

I wouldn't use a trigger unless absolutely necessary. This is a great use-case for Lightning Process Builder. It can update the parent record with a value from the child record. And without code!

Answer 3

I encountered a scenario just like this one, creating a custom opportunity product solution that needs to interact with the standard opportunity. The way I addressed this is by creating a custom roll-up field in the opportunity that adds all the amount of the child Quote__c (in your case) of the specific Opportunity. Based on your requirement I think this can be a solution if you just want to record every Quote__c amount on the Opportunity, but I’m not pretty sure if you have complex logic going on in the updating of the parent opportunity.

Answer 4

Simple and Easy

+++++++++++++++++++++++++++++++++++++++++++++++++++++++

Opportunity --> Child Object

Contact --> Parent Object

There is a lookup between these two object 'testtarun__c'

+++++++++++++++++++++++++++++++++++++++++++++++++++++++

trigger tarunopp on Opportunity (after update,after insert) {

list<id> opplist = new list<id>();

>for(opportunity opp:trigger.new)
    {
  >> opplist.add(opp.testtarun__c);

  >>  }

list<contact> conlist = new list<contact>();

conlist = [select id,phone, (Select id,testtarun__c from Opportunities ) from contact where ID IN : opplist];

for(contact con:conlist)


> {
>>      con.title='sohil sharma';
>>      con.Date__c=system.now();
>>      update con;     
> }

}

Answer 5

trigger Triggerupdate on person__c (after  update) { 
    List<Human__c> hum = new List<Human__c>();    
    List<Id> listIds = new List<Id>();

    for (person__c parentObj : Trigger.new) {
        listIds.add(parentObj.id);
    }

    hum = [SELECT id from Human__c  WHERE id__c IN :listIDs];

    for (Human__c opp : hum){
        for (person__c per: Trigger.new){
            opp.Age__c = per.Age__c;
        }
    }

    update hum;
}

Answer 6

I modified your code based on the description you provided. Here's the code I came up with. I believe this might work.

trigger UpdateAmount on Quote__c (after insert, after update) {

    List<Opportunity> parentObjList = new List<Opportunity>();
    List<Id> listIds = new List<Id>();
    List<Quote__c> newQuotes = new Quote[]{};

    for (Quote__c childObj : Trigger.new {
        listIds.add(childObj.Opportunity);
        newQuotes.put(childObj.Opportunity, Quote__c);
    }

   parentObjList = [SELECT id,Name FROM Opportunity WHERE ID IN :listIds];

   for (Opportunity opp : parentObjList){

       opp.Amount = newQuotes.get(opp.Id).Total_List_Price__c;

       update parentObjectList;
    }
}