Hi,
I have a custom radio button field and I want to create a calculated field that tracks the last time and the user who made changes to that field. I was already able to create a calculated field that tracks the last time and the value changes in the field. Thanks to this post - https://experienceleaguecommunities.adobe.com/t5/workfront-questions/custom-field-track-latest-date-...
Here is the current code for the calculated field that I managed to build:
LEFT(
IF(
LEFT({DE:Decision History - Initial Review}, LEN(IF(ISBLANK({DE:Assessment 1 - Initial Review}), "-", {DE:Assessment 1 - Initial Review}))) = {DE:Assessment 1 - Initial Review},
{DE:Decision History - Initial Review},
CONCAT(
IF(ISBLANK({DE:Assessment 1 - Initial Review}), "-", {DE:Assessment 1 - Initial Review}),
":",
$$NOW,
" ",
IF(LEN(MINUTE($$NOW)) > 1, CONCAT(HOUR($$NOW), ":", MINUTE($$NOW)), CONCAT(HOUR($$NOW), ":0", MINUTE($$NOW))),
" | ",
{DE:Decision History - Initial Review}
)
),
2000
)
Now, I need to add another piece of information to the same calculated field: the user or user ID who made the changes - without requiring them to enter their user information manually.
I would appreciate any insights on this matter. Million thanks!