Task Report - Update database columns when task gets re-assigned

Hello all,

We have a functionality in place to create tasks for a given case and capture or write the task report values to a table in database. Is there any way to capture or update the new values AssignedBy/AssignedTo along with time stamps to the initially created row in database?

Example:

Case 1 - User creates a task and assign to User A.

User A re-assigns the task to User B. We can see the new values (assignedTo = User B and Assigned By = User A, timestamps) in process report but we have to update the database table with these new values.

Can someone please let me know if there is a way to implement this?

Any help is greatly appreciated.

Thanks,

Ramesh

 Discussion posts and replies are publicly visible