Text_ID__c - text field with id of an Opportunity

A_Opportunity__c - lookup field to Opportunity

Both fields are in standard Account object. How can I populate the lookup field with the id in the text field? Will not work with workflow or process builder, guess I need Apex trigger (with which I have little experience). Can anyone provide code for this to at least put me on the right track? Would greatly appreciate it :)

  • Can you share your flow? I believe process builder + flow will allow this, as I've done so before – James Oct 28 '15 at 14:47
  • Hi James. The flow only allows to copy ID from a lookup field to another lookup field. Since my ID is in a text field, it is not giving me the option to reference it in the record update. – RA247 Oct 29 '15 at 15:35
  • Ah, makes sense. a workaround would be to use the lookup (text field) to query an object for the Id. From here, you can assign to your lookup field using flows/process – James Oct 30 '15 at 12:32

Something like this?

    trigger AccountTrigger on Account (before update,before insert) {
         for(account a : Trigger.New)
            a.lookupField__c = a.FieldWithID__c;

Your Answer

