Getting the newly changed field value

[Jeni Sebastian]

Hi guys

I'd  like to ask if there's any way to get the value of the newly update field in a table? Because i cant get the newly update value of a field by just using a table or by making a "report" in our custom table..  is there any way to make a list of the newly update field value every month?  

I'm now thinking of creating an extended table to our custom table to insert the value of the newly updated field then make a "report" out of it. I dunno if it's the best practice.. 

Note: this "HR Partner EID" field in our table  is updating every time the value of the "HR people advisor" field changes in the sys_user table.

custom table:

sys_user table

I'll appreciate any help. thanks!

[Mark Manders]

Why not turn on 'audit' on this table, so you will have the value in the activity stream every time it changes?

If my answer helped you in any way, please then mark it as helpful. If it resolved the issue, please mark it as correct.

Mark

[Mark Manders]

By the way: if it's only this field, I would create a metric for it, so you can report on that. If you need to know all fields, you are going to have to create a report on the sys_history_line table and that will become way more work.

If my answer helped you in any way, please then mark it as helpful. If it resolved the issue, please mark it as correct.

Mark