+ Start a Discussion
Jason ShoemakerJason Shoemaker 

Add contact email to the opportunity object.

I want add a lookup field to the opportunity object to display the email of the contact.

Currently, I'm using contact__r.email as the reference, but this is not displaying any information for existing contact.

How can I make this work?

Shailesh DeshpandeShailesh Deshpande
You cannot do that. Lookup fields can only contain Id's of the parent object, in this case, Contact Id. To get the email, you can use a formula field or create a trigger/Workfllow field update/ process builder.