Custom field track user who made changes and display in report | Community
Skip to main content
A
AsiatulAmir
June 13, 2024
Solved

Custom field track user who made changes and display in report

  • June 13, 2024
  • 1 reply
  • 805 views

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-time-amp-user-to-bring-into/m-p/590359#M53328

 

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!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Doug_Den_Hoed_AtAppStore

     

    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

    1 reply

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
    Community Advisor
    June 13, 2024

     

    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

      J
      Jeremy_Berquest
      Level 2
      April 30, 2025

      Doug- if you'll forgive a silly question. I'm trying to use the $$USER.name wildcard in a similar calculated field, but I get an invalid custom expression error when including ".name". The $$USER wildcard works fine if I don't include ".name", but obviously a human-readable result would be preferable over the returned User ID. Am I missing something obvious?

      Doug_Den_Hoed_AtAppStore
      Community Advisor
      Doug_Den_Hoed_AtAppStoreCommunity Advisor
      Community Advisor
      May 4, 2025

       

      Possibly @jeremy_berquest,

       

      If you post your formula attempt (and tag me using @doug_den_hoed__atappstore) I'd be happy to take a look.

       

      Regards,

      Doug

      Terms & ConditionsAccessibility statement

      Loading footer...