Expand my Community achievements bar.

SOLVED

Track custom field updates by date and user

Avatar

Level 3

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!
1 Accepted Solution

Avatar

Correct answer by
Level 4

Have you tried $$USER.{name} ?

View solution in original post

2 Replies

Avatar

Correct answer by
Level 4

Have you tried $$USER.{name} ?

Avatar

Level 3

Worked perfect with some tweaks

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

Many thanks!