Calculated field to capture who updated a field?

Forum|Forum|4 years ago
February 22, 2021
4 replies
1510 views

Hi WF Community,

You know how you can see what user updates a field when you look at the Updates tab for a given record? I'm wondering if there's a way to create a calculated field that would capture the person's name?

For example:

If Joe Smith updated the field Internal Error Tracking (custom dropdown field) to 'Inaccurate', the new custom field called Error Entered By would populate Joe Smith's name in it.

I have a custom calculated field that does this for date/time stamping when a field value is updated, and wondering if it can be repurposed to capture a user's name? Here's my date/time stamp calculated formula:

IF(Internal Error Tracking="Incomplete",$$NOW,IF(Internal Error Tracking="Inaccurate",$$NOW,""))

Thanks.

Nick

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

S

SarahNa

Level 6

Hey Nick,

I don't believe that this is possible at the moment, but @Jeremy Flores‚ is working on a solution for this. Jeremy - this hasn't been implemented yet, correct?

Thanks,

Sarah

jerflo

Adobe Employee

@Sarah Nau‚ thanks for looping me in. Hi, all. So the new journal entry report that is currently in Preview will allow you to track fields as long as the "display in updates feed" setting is toggled on for the field. For calculated fields, this isn't possible. However, it might be in the plan to add custom fields to the audit logs which would allow for this. Adding @Gevorg Kazaryan‚ to keep me honest and to elaborate, if needed.

M

MichelleBo3

Level 4

@Jeremy Flores‚ where is that "display" toggle located?

A

AdinaPi1

Level 9

Yes, it is possible! It requires 2 custom fields, otherwise when you make any other update on that form, it would change the date to now.

I attached a screenshot of what it would look like on the form.

1st field: your Internal Error Tracking field

2nd field: new calculated field called Internal Error Tracking Updated , format=text,

Calculation (click apply before inputting):

IF(Status=LEFT(Internal Error Tracking Updated,LEN(Internal Error Tracking Updated)-LEN(" - ")-1),CONCAT(Internal Error Tracking," - 0"),CONCAT(Internal Error Tracking," - 1"))

3rd field: new calculated field called Internal Error Tracking with Date, format = text

Calculation (click apply before inputting)

IF(RIGHT(Internal Error Tracking Updated,1)=1,CONCAT(Internal Error Tracking," updated by ",{lastUpdatedBy:name}," on ",$$NOW), Internal Error Tracking with Date)

Here is what it looks like on the task/project/issue:

The only thing I haven't figured out how to do is to make the time stamp in addition to the date on a text calculation (it works fine on a date format)