Change Lead "created date" when assign it to user

[Riad]

Hello,
1- I want to Change Lead "created date" when assign it to user. So the created date of the Lead will be the same date of assign.
2- As Admin with mass update want to make lead unfollow for any user I want. (Can change lead Followers)
Thank you

[rabii]

1- you can use before script formula under Administration > entity manager > lead > formula > before save custom script (use the code below)

if(entity\isAttributeChanged('assignedUserId') && assignedUserId) {
    createdAt = datetime\now();
} 

This code will update the created at date to now() date once the assigned user is changed and there is an assigned user.

2- check this out it might help

https://forum.espocrm.com/forum/general/114491-mass-unfollow-option-for-users

[rabii]

The if(){} has been introduced in version 7.4 so any version below this you should use the old formula ifThen instead. check documentation.

[Riad]

Can you type the the correct formula for v. 7 Please. Thank you

[Riad]

ifThen(
and(
entity\isAttributeChanged('assignedUserId'),
assignedUserId
),
createdAt = datetime\now()
)

This not work

[lazovic]

Hi Riad,

Please try to use the following formula script:

ifThen(
  entity\isAttributeChanged('assignedUserId') && assignedUserId,
  createdAt = datetime\now()
);