You need to sign in to do that
Don't have an account?
SBP Admin User
Cross object Formula field referencing standard object
Hi There,
I have a custom object called SBP, On the object I have 2 look up fields to the Contact object "Principal" and "SBP Coordinator"
I'm trying to build a custom formula field which will provide the Principal email address from the Contacts oject and another formula field for the SBP Coordinator email address.
In the Custom formula field creator these fields are not available.
Can I simply write out the formula manually something like "Principal_{!Contact_MyEmail_c" to get it to work?
Or is there an issue as due to 2 formula fields?
Thanks
I have a custom object called SBP, On the object I have 2 look up fields to the Contact object "Principal" and "SBP Coordinator"
I'm trying to build a custom formula field which will provide the Principal email address from the Contacts oject and another formula field for the SBP Coordinator email address.
In the Custom formula field creator these fields are not available.
Can I simply write out the formula manually something like "Principal_{!Contact_MyEmail_c" to get it to work?
Or is there an issue as due to 2 formula fields?
Thanks
simply write you writte formula for SBP Coordinator email address= Contact__r.Email
And other formula is=SBP_Coordinator__r.Email
contact have relationship SBP so when mve on lookup field
when you create formual then you go Advance formala and go according to above img.
Thanks
Rupal Kumar
http://Mirketa.com
All Answers
simply write you writte formula for SBP Coordinator email address= Contact__r.Email
And other formula is=SBP_Coordinator__r.Email
contact have relationship SBP so when mve on lookup field
when you create formual then you go Advance formala and go according to above img.
Thanks
Rupal Kumar
http://Mirketa.com