I have sugarCRM 6.5.20 OnDemand. I'm in the studio. I have a 1: 1 ratio from Leads to Leads. I am trying to get the primary email address of the associated Witness and display it in the calculated field.
It looks like the calculated field formula should look like this:
related($emails,"email1")
When I do this, I get the following error:
Invalid formula: related: Unknown Field : email1
There is no list in the drop-down list. How can I get an email? All my internet searches have been ineffective.
Update:
I am ready to make the calculated field the primary email address of the current manual. For this, I found 2 variables with the names $email_addressesand $email_addresses_primaryand $emails. There is also a function called valueAt.
I tried to use valueAt(1,$emails)andvalueAt(1,$email_addresses)
, .
?