You need to sign in to do that
Don't have an account?
Saad Ahmad 27
Trigger to Auto Populate Lookup Fields based on field values
I have 10 look up fields that need to be updated based on 10 text fields on the custom object. The text field contains the user ID of a person and this field is used to fill out the look up field.
e.g. CDS User ID (text field) = 12345, the look up field (related to User object) will be updated with user who's federation identifier = 12345.
I have written a trigger to update 1 look up field but i'm unable to expand this to include all 10 fields.
e.g. CDS User ID (text field) = 12345, the look up field (related to User object) will be updated with user who's federation identifier = 12345.
I have written a trigger to update 1 look up field but i'm unable to expand this to include all 10 fields.
trigger UpdateUserOnRepairHistory on Repair_History__c (before insert, before update) { Map<String, Repair_History__c> RepHistorytoUser = new Map<String, Repair_History__c>(); for (Repair_History__c rH:Trigger.new) { RepHistorytoUser.put(rH.CDS_End_User_ID__c, rH); } List<User> userList = [SELECT Id, FederationIdentifier from User where FederationIdentifier in :RepHistorytoUser.keySet()]; for (User usr : userList){ RepHistorytoUser.get(usr.FederationIdentifier).CDS_End_User_Name__c = usr.Id; } }