Trigger to update parent records field when child record is updated

Post Views: 4,353

Hey guys, today in this post we are going to learn about How to update the parent record field based on child record trigger in Salesforce custom object

Real time scenarios:- Write a trigger on custom object where update parent records field whenever child record is inserted or updated.

Create two custom object, both are associated with lookup relationship with each other

1) Custom Object:- parentObjTrigger__c custom field:- Status__c (Checkbox boolean type)
2) Custom Object:- childObjTrigger__c custom field:- Status__c (Checkbox boolean type)

If status field of child object marked true then should be status field of parent object automatic marked as true.

Don’t forget to check out:- Apex Trigger on Contact to Create Account Automatically and map to related account Id to Contact Whenever New Contact is Created in Salesforce Click Here For More Information

Files we used in this post example:-

checkboxStatus.apxt

Apex Class Trigger

It is used for update parent object field based on child records

Custom Parent Object:- parentObjTrigger__c

Custom Field :- Status__c

Custom Parent Object with Custom Field

It is parent custom object used for building a lookup relationship with childObjTrigger__c

Custom Child Object:- childObjTrigger__c

Custom Field:- Status__c

Custom Child Object with Custom Field

It is child custom object that is lookup relationship and associated with parentObjTrigger__c

You can download file directly from github by click here

Final Output

Other related post that would you like to learn.

Step 1:- Apex Class Trigger : checkboxStatus.apxt

From Developer Console >> File >> New >> Apex Trigger

checkboxStatus.apxt [Apex Class Controller]

  trigger checkboxStatus on childObjTrigger__c (before Insert, before update, after insert, after update, before delete, after delete) {
    if(trigger.isBefore){
        //system.debug('I am inside before event');   
    }
    else if(trigger.isAfter){
        //system.debug('I am inside after event');
        
        if(trigger.isUpdate){        
            for(childObjTrigger__c myStatus: Trigger.new){      
                parentObjTrigger__c getParentObj = [SELECT Id, Status__c FROM parentObjTrigger__c WHERE Id = :myStatus.childLookup__c ];         
                childObjTrigger__c getChildObj = [SELECT Id, Status__c, childLookup__r.Status__c FROM childObjTrigger__c WHERE Id = :myStatus.Id];                  
                getParentObj.Status__c= getChildObj.Status__c;
                update getParentObj;         
            }
            
        }
        
        
        if(trigger.isInsert && (trigger.isAfter)){
            for(childObjTrigger__c myStatus: Trigger.new){
                parentObjTrigger__c getParentObj = [SELECT Id, Status__c FROM parentObjTrigger__c WHERE Id = :myStatus.childLookup__c ];         
                childObjTrigger__c getChildObj = [SELECT Id, Status__c, childLookup__r.Status__c FROM childObjTrigger__c WHERE Id = :myStatus.Id];
                getParentObj.Status__c= getChildObj.Status__c;        
                update getParentObj;
            }   
        }
        
        
        if(Trigger.isDelete && (Trigger.isBefore)){
            for(childObjTrigger__c myStatus: Trigger.old){          
                parentObjTrigger__c getParentObj = [SELECT Id, Status__c FROM parentObjTrigger__c WHERE Id = :myStatus.childLookup__c ];         
                childObjTrigger__c getChildObj = [SELECT Id, Status__c, childLookup__r.Status__c FROM childObjTrigger__c WHERE Id = :myStatus.Id];                           
                delete getParentObj;
            }   
        }   
        
    }
    
    
}

trigger checkboxStatus on childObjTrigger__c (before Insert, before update, after insert, after update, before delete, after delete) {

if(trigger.isBefore){

//system.debug('I am inside before event');

}

else if(trigger.isAfter){

//system.debug('I am inside after event');

if(trigger.isUpdate){

for(childObjTrigger__c myStatus: Trigger.new){

parentObjTrigger__c getParentObj = [SELECT Id, Status__c FROM parentObjTrigger__c WHERE Id = :myStatus.childLookup__c ];

childObjTrigger__c getChildObj = [SELECT Id, Status__c, childLookup__r.Status__c FROM childObjTrigger__c WHERE Id = :myStatus.Id];

getParentObj.Status__c= getChildObj.Status__c;

update getParentObj;

}

if(trigger.isInsert && (trigger.isAfter)){

for(childObjTrigger__c myStatus: Trigger.new){

parentObjTrigger__c getParentObj = [SELECT Id, Status__c FROM parentObjTrigger__c WHERE Id = :myStatus.childLookup__c ];

childObjTrigger__c getChildObj = [SELECT Id, Status__c, childLookup__r.Status__c FROM childObjTrigger__c WHERE Id = :myStatus.Id];

getParentObj.Status__c= getChildObj.Status__c;

update getParentObj;

}

if(Trigger.isDelete && (Trigger.isBefore)){

for(childObjTrigger__c myStatus: Trigger.old){

parentObjTrigger__c getParentObj = [SELECT Id, Status__c FROM parentObjTrigger__c WHERE Id = :myStatus.childLookup__c ];

childObjTrigger__c getChildObj = [SELECT Id, Status__c, childLookup__r.Status__c FROM childObjTrigger__c WHERE Id = :myStatus.Id];

delete getParentObj;

}

TechW3web:- To know more, Use this Link

Other related post that would you like to learn

The Sitemap to Find all Published Post of The Tutorial w3web.net Click Here For More Information

To Find Some Important Additional Information

If you think you and your family members also like to earn money in additional time, then go this link. In this site, you can earn money for the lifetime at low effort. To Earn Unlimited Everyday With This Trick, Sign Up Free and Get Magic.. Get Started for Free