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
Hello Alex,
You are getting the "Array" response because emails are usually stored in an Array. You are calling the Array, not the elements. What you need to do is select the email element from the Array and display it in your field. Please see the image below.
Your formula is: related($atc_clientsalesreps_atc_appointments,"email")
The new formula is: related($atc_clientsalesreps_atc_appointments,"email1")
Please notice that I write "email1" instead of "email". This way you are able to select the first element of the Array.
In order to implement this approach, you need to have a relationship between these two modules.
Sergio N.
Hello Alex,
You are getting the "Array" response because emails are usually stored in an Array. You are calling the Array, not the elements. What you need to do is select the email element from the Array and display it in your field. Please see the image below.
Your formula is: related($atc_clientsalesreps_atc_appointments,"email")
The new formula is: related($atc_clientsalesreps_atc_appointments,"email1")
Please notice that I write "email1" instead of "email". This way you are able to select the first element of the Array.
In order to implement this approach, you need to have a relationship between these two modules.
Sergio N.
