Solved
Track custom field updates by date and user
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!