Details about this thread
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 4 replies
  • Subscribers 294 subscribers
  • Views 1924 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

    I think email retrieved is something like:

       "email":[      
    {"email_address":"me@my.crm"
    ,"primary_address":"1"
    ,"invalid_email":"0"
    ,"opt_out":"0" }]

    You could try using email1, though I seem to recall reading somewhere that it is going away.

    Is your heart set on using Sugar Logic? You could use a before save to retrieve the email address and populate the field or, depending on your scenario, use the controller to fetch and populate the email address in your field before the user saves the record.

    HTH

    Francesca

Reply
  • 0

    I think email retrieved is something like:

       "email":[      
    {"email_address":"me@my.crm"
    ,"primary_address":"1"
    ,"invalid_email":"0"
    ,"opt_out":"0" }]

    You could try using email1, though I seem to recall reading somewhere that it is going away.

    Is your heart set on using Sugar Logic? You could use a before save to retrieve the email address and populate the field or, depending on your scenario, use the controller to fetch and populate the email address in your field before the user saves the record.

    HTH

    Francesca

Children
No Data