Need logic for getting custom field "Modified by " populated

Question

There is this Workflow object which has a task list to be completed. Say under WF there are 4 tasks. We need to track who has modified the respective tasks and when.

Currently only one last modified is there standard one which gives for the full checklist. We need individually for each task.

Tried using lookup relationship with user but its not working.

Amnon Kruvi · Accepted Answer

Ahhh, you have 4 sets of fields? The correct way to handle this use case would be with child "Task" objects. This data model will cause you a lot of hassle going forward.

If you insist on using this, then you will need to do the following:

1. Create a lookup field to User x4 (one per task)

2. Create a date-time field x4

3. Using process builder, set a criteria that checks if any of the task 1 fields had changed (with an OR relationship between them)

4. Add an action that sets task 1's lookup to the formula $User.id, and the date time field to NOW()

5. Repeat for all other tasks

ADMIN TBTC MC · Answer

Thanks for the possible solution. but while adding an action , i m not able to fetch the user id.

Need logic for getting custom field "Modified by " populated

Data Management

관련 학습

도움 더 받기