[SalesForce] how to add child record fields into a single field in Parent object using trigger

I have two objects Child__c and Parent__c with master detail relationship. so when a record is inserted or updated I want add Field1__c and Field2__c to the Parent custom field concatenate__c with comma seperated(field1__c,Field2__c).

If there are multiple child records I want to seperate them with ':'
for example :field1__c,Field2__c:field1__c,Field2__c….

I tried the below code but when an update is made it is updating with new value

Trigger:

trigger updateVals on Child_object__c (after Insert, after Update) 
{

    List<Parent_object__c> poList = new List<Parent_object__c>();
    Set<Id> Po_Ids= new Set<Id>();

    for (Child_object__c childObj : Trigger.new ){
        Po_Ids.add(childObj.ParentLookup__c);
    }

    if(Trigger.IsInsert||Trigger.IsUpdate){
        List<Parent_object__c> po=[Select Id,concatenate__c from Parent_object__c where ID IN: Po_Ids]; 

        for(Parent_object__c p : po){
            for (Child_object__c c: Trigger.new){
                p.concatenate__c = c.field1__c +','+ c.fiedl2__c;
                poList.add(p);

            }
        }

        update poList ;
    }    
}

Best Answer

The latest value is updated in the parent because you are not concatenatine the value of concatenate__c in parent record, you are replacing it. Also you are not fetching the other child records present under the parent

Query all the parents records and Child records associated with the parents for which the childs are edited.
Create a string and concatenate the values for child fields.
Assign this value to parent field.

Update the parent record.

trigger updateVals on Child_object__c(after Insert, after Update) {

List < Parent_object__c > poList = new List < Parent_object__c > ();
Set < Id > Po_Ids = new Set < Id > ();

for (Child_object__c childObj: Trigger.new) {
    Po_Ids.add(childObj.ParentLookup__c);
}


if (Trigger.IsInsert || Trigger.IsUpdate) {
    List < Parent__c > po = [Select Id, Concatenate__c, (Select field1, field2 from Child__r) from Parent__c where Id IN: Po_Ids];
    for (Parent_object__c p: po) {
        String concatenateString = '';
        for (Child_object__c c: p.Child__r) {
            concatenateString += c.field1__c + ',' + c.fiedl2__c + ' : ';

        }
        p.Concatenate__c = concatenateString;
        poList.add(p);
    }


    update poList;

}

}

Related Solutions

[SalesForce] Update parent field with field from child record

I would create a custom button on the child object page layout. This button would open a VF page. I would use the action attribute of that page to do this logic, and then return the user to the child record.

<apex:page StandardController="Child__c" extensions="customExtension" action="{!copyFirmwareField}"/>

Apex

public class customExtension{

     private final Child__c myChild;

     public CheckForExpiredMilestonesNowExtension(ApexPages.StandardController stdController){
          this.myChild = (Child__c)stdController.getRecord();
          this.myChild = [Select Id, Name, Parent__c From Child__c Where Id =: myChild.Id];
     }

     public PageReference copyFirmwareField(){
          Parent__c parent = new Parent__c(Id = myChild.Parent__c, Firmware__c = myChild.Firmware__c);
          update parent;
          PageReference page = new PageReference('/' + myChild.Id);
          page.setRedirect(true);
          return page;
     }
}

[SalesForce] Need to fire trigger on child objects when parent object is updated

On the rollup question only...

This is a case where it is probably worth factoring out the code that does the rollup into a separate class. That then allows the triggers to be fairly simple:

trigger ParentTrigger on Parent__c (before ...) {
    if (change detected) {
        // Trigger objects will be persisted so just copy result
        for (Parent p : ChildRollup.calculateParents(Trigger.newMap)) {
            Trigger.newMap.get(p.Id).Sum__c = p.Sum__c;
        }
    }
}

trigger ParentTrigger on Parent__c (after ...) {
    if (change detected) {
        update ChildRollup.calculateParents(Trigger.newMap);
    }
}

trigger ChildTrigger on Child__c (...) {
    update ChildRollup.calculateParents(Trigger.newMap);
}

and sharing most of the code:

public class ChildRollup {
    public static Parent__c[] calculateParents(Map<Id, Parent__c> parents) {
        return calculateParents(parents.keySet());
    }
    public static Parent__c[] calculateParents(Map<Id, Child__c> children) {
        Set<Id> parentIds = new Set<Id>();
        for (Child__c c : children.values()) {
            parentIds.add(c.Parent__c);
        }
        return calculateParents(parentIds);
    }
    private static Parent__c[] calculateParents(Set<Id> parentIds) {
        Map<Id, Parent__c> parents = new Map<Id, Parent__c>();
        for (Id parentId : parentIds) {
            parents.put(parentId, new Parent__c(Id = parentId, Sum__c = 0.00));
        }
        for (AggregateResult ar : [
                select Parent__c p, sum(Value__c) s
                from Child__c
                where Parent_c in :parentIds
                group by Parent__c
                ]) {
            parents.get((Id) ar.get('p')).Sum__c += (Decimal) ar.get('s');
        }
        return parents.values();
    }
}

Best Answer

Related Solutions

[SalesForce] Update parent field with field from child record

[SalesForce] Need to fire trigger on child objects when parent object is updated

Related Topic