Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

Custom field track user who made changes and display in report

Avatar

Level 1

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!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

 

Well done @AsiatulAmir,

 

To include the name of the currently logged in user, I suggest you add the following on a new line above the “ | “, line:

 

“ “, $$USER.name,

 

See here for a list of other such useful wildcards.

I also invite you to review the original Targeted Auditing post for more ideas and details.

 
Regards,

Doug

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

 

Well done @AsiatulAmir,

 

To include the name of the currently logged in user, I suggest you add the following on a new line above the “ | “, line:

 

“ “, $$USER.name,

 

See here for a list of other such useful wildcards.

I also invite you to review the original Targeted Auditing post for more ideas and details.

 
Regards,

Doug