Skip to main content

Hello,

 

OFB does not work for cross objects field dependency, (https://ideas.salesforce.com/s/idea/a0B8W00000GdiqwUAB/crossobject-field-dependencies)

Any Apex, Apex trigger, etc would work?

we have 2 custom objects.  the multi-picklist field of the child should default to the parent multi-picklist.  

thx!

1 answer
  1. May 16, 2023, 5:07 AM

    @Lily Chung apex trigger should work. Try this.

     

    trigger CrossObjectDependency on Child_Object__c (before insert, before update) {

    // Get the parent object IDs

    Set<Id> parentIds = new Set<Id>();

    for (Child_Object__c child : Trigger.new) {

    parentIds.add(child.Parent_Object__c);

    }

    // Query the parent objects

    Map<Id, Parent_Object__c> parents = new Map<Id, Parent_Object__c>([

    SELECT Id, Multi_Picklist_Field__c

    FROM Parent_Object__c

    WHERE Id IN :parentIds

    ]);

    // Set the child object values

    for (Child_Object__c child : Trigger.new) {

    Parent_Object__c parent = parents.get(child.Parent_Object__c);

    if (parent != null) {

    child.Multi_Picklist_Field__c = parent.Multi_Picklist_Field__c;

    }

    }

    }

0/9000