Get email from related contact

I've added a Related Contact field (operational_contact_c) to the Accounts module. I now want to to add a calculated field that returns the email address for the Related Contact. I have played around with a few formulae but can't figure out how to do it. Does anyone have a solution?

Thanks!

Dan

Parents

0 Patrick McQueen over 5 years ago

Hi Daniel Taylor,

Is that a custom relationship or just a relate-type field made in Studio?

If it is just a relate-type field, those modules/records are not actually related, so no formula can be used to pull data across a relationship.

Some helpful docs on these subjects:

https://support.sugarcrm.com/Knowledge_Base/Studio_and_Module_Builder/Introduction_to_Relationships_and_Relate_Fields/

https://support.sugarcrm.com/Knowledge_Base/Studio_and_Module_Builder/Understanding_Relationship_Creation_Options/

https://support.sugarcrm.com/Knowledge_Base/Studio_and_Module_Builder/Creating_a_Relationship/

I hope this helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Daniel Taylor over 5 years ago in reply to Patrick McQueen

Hi Patrick,

It's a relate-type field made in Studio so that'll be the reason why I can't do it then. Doh!

Will take a look at those articles you've referenced.

Thanks,
Dan
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Daniel Taylor over 5 years ago in reply to Patrick McQueen

Hi Patrick,

It's a relate-type field made in Studio so that'll be the reason why I can't do it then. Doh!

Will take a look at those articles you've referenced.

Thanks,
Dan
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data