• SFDC Drona
  • 5 Points
  • Member since 2017

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 1

I want to send a workflow email alert to the address in an email field on a record that is the parent of the record being processed.

There doesn't appear to be a way to do that.  I can reference parent fields all I want in the Formula that qualifies the Workflow.  But in the Email alert, when I select "Email Field", I only get Email fields in the actual record, not parent fields available.


The only work around I have found for this restriction is to write Apex code to copy the email field value of the parent into an email field on the child record.  That is really a pain.  It's never good to copy stuff around.  To keep in sync, both objects need update triggers that cascade update other records.


If a formula field could be of type email, I could define a formula field on the child that references the parent field.  But formula fields can't be type email.  (I added an Idea to allow that. feel free to vote up https://success.salesforce.com/ideaView?id=08730000000kwYAAAY.)


Without that feature I can't think of any way to do using definition features, only Apex.


Anyone have any ideas for another workaround for this issue?