Update Contact Email Using Formula

[Pablo]

Hi,

We have a strange case. We have a varchar field called "VIP Email" at the Contacts module.

We have created a simple formula that copies the value of VIP Email into the contact's email field (check attachment).

emailAddress=vipmail;

However, each time we create or update a contact, the contact's email is NOT updated. We have also tested in the demo of EspoCRM but we get the same result.

Are we doing anything wrong?

Thanks a lot for your time.

[item]

Hello,
it's not strange .. i think it's "normal" and it's perfect so

this work on backEnd.. don't know on formula :

$o = (object) [
'emailAddress' => $email,
'primary' => true,
];

// and then

$user->set([
'userName' => $userName,
'salutationName' => 'Mrs.',
'firstName' => $firstName,
'lastName' => $lastName,
'type' => 'regular',
'isAdmin' => 0,
'isActive' => $isActive,
'gender' => 'Female',
'emailAddressData' => [$o],
'assignedUserId' => '1'
]); 

[Pablo]

Hi item ,

Thanks for the help. However, I don't think it's what I'm looking for.

Is there any way to update the emailAddress field using the entity's formulas from the admin panel?

Thanks.

[eymen-elkum]

Hi Pablo,

Espocrm email address field is not a simple varchar, so cannot directly write to the "emailAddress" you only can read from it because it is calculated from the linked emails array (the primary one).

To set the email address you need to work with "emailAddressData" as item mentioned above :

NOTE: this will overwrite the data you insert in the form email field.

[eymen-elkum]

Actually it is worked here, I also was surprised!

[eymen-elkum]

I confirm it is working on the version 6 beta, not tested on previous versions

[esforim]

Imagine if it considered a bug and loophole get fix XD

[Pablo]

Hi eymen-elkum ,

Thanks for the help. As yuri said, it didn't work on version 5.9.3.

"Though it's possible to unset emailAddressData to avoid re-writing by the value passed from the form."

yuri: Any tips to unset emailAddressData using a formula?

Thanks a lot.