function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
AdammmAdammm 

Port over HTML Email Status to 'Lead Detail' Table

I would like to port over a field in the HTML Email Status Table to the 'Lead Detail' Table. The value I would like to port is HTML_Email_Status.Last_Opened. I would like to make this value available in the Lead Detail table.
 
I was thinking I might execute a join statement based off of the common information in both tables. Both Tables have the 'lead name' field.
 
I've never executed anything like this in Salesforce before, could someone point me in the right direction as far as how to make a change like this? Would I use the Ajax tool?
 
 
Thanks for your help!
 
 
-Adam