Can record\exists formula Value be from another Entity?

[JosNas]

I'm checking if an Account record exists based on the value of the accountName field in a Lead record. If it exists, I don't want to create a record in 'Accounts', else create the record.

Can I do it like this using the workflow formula (target Entity is 'Lead '):

ifThen(
!record\exists('Account', 'name=', accountName),
record\create('Account', 'name', accountName))

[eymen-elkum]

You can use record\findOne:

$accId = record\findOne('Account', 'createdAt', 'desc', 'name=', accountName);
ifThen(
    $accId == null,
    record\create('Account', 'name', accountName));
);

[JosNas]

thank you this worked like a charm!

[eduardofendrich]

Should this work in the following situation?

User has a team assigned. User is creating a contact. I would like to set contact's team to the same user's team.

How can I get current user settings in formula? Does '$this' works?


Thanks

[eymen-elkum]

Yes you can use: env\userAttribute('teamsIds')