Track custom field updates by date and user

[LukaszMa]

Hi All,

I have seen similar threads elswhere but not found an anwser I need.

I have a custom field "Credit Approval Status" which is a 3x choice dropdown (pending, approved, rejected). I want to return date and name of the user who made the change in a calculated field DE:Approved by . So far I managed to pull the date and ID but unable to get the name result out of the below expression. Any ideas?

Current result for DE:Approved by is "Rejected (22/03/24) by 62ebccf6002c9e840c3aafe72cc9f158"

LEFT(IF(LEFT({DE:Approved by},LEN(IF(ISBLANK({DE:Credit Approval Status}),"-",{DE:Credit Approval Status})))={DE:Credit Approval Status},{DE:Approved by},CONCAT(IF(ISBLANK({DE:Credit Approval Status}),"-",{DE:Credit Approval Status})," (",$$NOW,") by ",$$USER)),2000)

Thanks in advance!

[TravisGrogan1 · Accepted solution]

Have you tried $$USER.{name} ?

[LukaszMa]

Worked perfect with some tweaks

"on ",$$NOW," by ", $$USER.{name}

Many thanks!