[SalesForce] Update related object in trigger

I have custom object People__c that has lookup field Married__c to the same object (People__c) and I want to create a trigger for auto update after insert and update. For example, if we insert new People__c (husband) or modify it and add in lookup field another People__c (wife) then wife must have in her lookup field automatically added husband and conversely.

I've written the next code but it doesn't work. What could I try instead?

trigger InsertUpdateMarried on People__c (after insert, after update) {

    Set<Id> peopleMarriage = new Set<Id>();
    for(People__c people : trigger.New) {
        peopleMarriage.add(people.Married__c);
    }

    Map<Id,People__c> matchingPeopleMap = new Map <Id,People__c>();

    for (People__c people : [Select Id, Married__c From People__c Where Id IN :peopleMarriage]) {
        matchingPeopleMap.put(people.Id, people);
    }

    List<People__c> peoplesToUpdate = new List<People__c>();

    for(People__c people : trigger.New) {

        if (matchingPeopleMap.containsKey(people.Id))

        {

            people.Married__c = matchingPeopleMap.get(people.Id).Id;

            peoplesToUpdate.add(people);

        }

    }

    update peoplesToUpdate;

}

Best Answer

This can all be reduced to the following. No queries needed as you did not ask to check if the field on the related person was already populated or not

Note The block of updating records that are in the trigger. You will need to figure out how to handle People in the trigger that are related to people in the trigger

trigger InsertUpdateMarried on People__c (after insert, after update) {

    Map<Id,Id> peopleMarriage = new Map<Id,Id>();

    for(People__c people : trigger.New) {
        //Populate related Id to This Person Id
        if(people.Married__c == null || trigger.newMap.containsKey(people.Married__c)) continue; //Prevent from updating itself will need to fingure out how you want to handle it
        peopleMarriage.(people.Married__c, people.Id); //Related person Id mapped to THIS person
    }

    Map<Id,People__c> peoplesToUpdate = new Map<Id,People__c>();

    for(Id peoplePartner : peopleMarriage.keyset()){
        //update the Related Person lookup to the value of This person
        peoplesToUpdate.put(
            peoplePartner,
            New People__c(
                Id = peoplePartner,
                Married__c = peopleMarriage.get(peoplePartner)
            )
        );
    }


    update peoplesToUpdate.values();

}

You will need to handle recursion since you are updating records that are part of the same object. Best to move all logic to a class but the above will give you an idea of what you need to do

Basically what it does is

For each record in the trigger that has a Married__c value
Create an instance of a People Record
Set the Id of that #2 record to the related Trigger record Married__c
Set the Married__c of that #2 record to the Id of the matching trigger record
Updates the related person records

Related Solutions

[SalesForce] Trigger to autopopulate a lookup field via related record

You can do something like this. Basically you would need to get the opportunities of all the records that you're inserting / updating, get the associated accounts and then set the account values in the customOject's account__c field.

trigger autoPopulateTrigger on customObject__c (before insert, before update){

    //get the oppotyunity Id's and store it in a set.
    set<Id> opptyIdSet = new set<Id>();
    for(customObject__c co: trigger.new){
        if(co.opportuntiy__c != null){
            opptyIdSet.add(co.opportunity__c);
        }
    }

    //query the opportunity records and get the associated accounts.
    map<id, opportunity> opptyMap = new map<id, opportunity>{[SELECT id, accountid from opportunity where Id IN: opptyIdSet]};

    //update the account value based on the opportunity in the record.
    for(customObject__c co: trigger.new){
        if(opptyMap.containsKey(co.opportunity__c)){
            co.Account__c = opptyMap.get(co.opportunity__c).accountId;
        }       
    }

}

[SalesForce] Trigger to copy child object picklist values to parent object separated by comma

The code you have shared will not at all compile.

use close brace here for (Opportunity childObj : Trigger.new)
use childObj.AccountId instead of childObj.Account to access AccountId
When you use relationship query be sure to use Opportunities instead of Opportunity.
You should put Opportunity's Opp_Location__c into a List. Then use String.join() to add those with comma delimited.
And finally update accounts.

Trigger

trigger UpdateAmount on Opportunity (after insert, after update) { 
  Map<ID, Account > parentOpps = new Map<ID, Account>(); 
  Set<Id> listIds = new Set<Id>();

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

  parentOpps = new Map<Id, Account>([SELECT id, Location_Type__c ,
                                        (SELECT ID, Opp_Location__c  FROM Opportunities) 
                                    FROM Account WHERE ID IN :listIds]);

  List<Account> lstAccount = new List<Account>();

  for(Account acct:parentOpps.values())
  {  
      List<String> strType = new List<String>();
      for(Opportunity oppty:acct.Opportunities)
      {
          strType.add(oppty.Opp_Location__c);
      }
      acct.Location_Type__c = String.join(strType,',');

  }

  update parentOpps.values();
}

Best Answer

Related Solutions

[SalesForce] Trigger to autopopulate a lookup field via related record

[SalesForce] Trigger to copy child object picklist values to parent object separated by comma

Related Topic