Problem with formula record\findOne

[LuckyLouie]

Hello,
I would like to extract the id of a contact with the email address: test@gmail.com
Can someone help me find a mistake in the formula?

$em = 'test@gmail.com';
$ids = record\findOne('Contact', 'createdAt', 'desc', 'emailAddress=', $em);​

[lazovic]

Hi LuckyLouie,

The formula is correct, it works as it should, it was checked through the Formula Sandbox on EspoCRM v7.4.3.



Are you sure that there is a Contact with this email address in the instance? Does this formula work with other entities or other fields?