Details about this thread
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 4 replies
  • Subscribers 294 subscribers
  • Views 1923 views
  • Users 0 members are here
Related content from around SugarClub

Creating a calculated field using Email of a related Record

Alex Wilder

In studio, when creating a calculated field for a related record, I'm not able to select Email.

Here's the formula I'm using:

related($atc_clientsalesreps_atc_appointments,"email")

After saving that formula and Mass Updating both the parent record and related record, the calculated field returns 'Array' instead of the expected email address of the related record.

Any help would be much appreciated!

Thanks,

Alex

Parents
  • 0

    Hello Alex Wilder

    I was able to get the email from a related record following these steps:

    Module A: Source record.

    Module B: Target record.

    Create a calculated text field in module A, let's name it module_a_email_c and set this formula in:

    related($email_addresses,"email_address")

    Create a calculated text field in module B, let's name it email_from_a_c and set this formula in:

    related($module_a,"module_a_email_c")

    Keep in mind that there should be an actual relationship between these two modules. 

    I hope this helps.

    Regards, 

    Angel M.

Reply
  • 0

    Hello Alex Wilder

    I was able to get the email from a related record following these steps:

    Module A: Source record.

    Module B: Target record.

    Create a calculated text field in module A, let's name it module_a_email_c and set this formula in:

    related($email_addresses,"email_address")

    Create a calculated text field in module B, let's name it email_from_a_c and set this formula in:

    related($module_a,"module_a_email_c")

    Keep in mind that there should be an actual relationship between these two modules. 

    I hope this helps.

    Regards, 

    Angel M.

Children
No Data