Capture Last Modified by and date on when a row has been changed

[Tony_Landowski]

My team would like to have a column that shows who was the last person to modify the record.  Has anyone implemented a process to capture the person and date/time a change was made?  If yes, what steps did you take to set this up?

[SkrOYC · Accepted solution]

All my tables has a Modified by column. Just add USEREMAIL() in the app formula, it's that simple

[SkrOYC · Accepted solution]

All my tables has a Modified by column. Just add USEREMAIL() in the app formula, it's that simple

[Tony_Landowski]

Thank you.  Have you tried to capture the date and time this change was made?

[Suvrutt_Gurjar · Accepted solution]

Please add another datetime type column with app formula as NOW() to capture the date and time when a row was edited.

[Tony_Landowski]

Thank you

[Suvrutt_Gurjar]

You are welcome.

[MultiTech]

I've got a set of columns that I use as a "Standard Starting Template" that includes a bunch of columns like this.  You can learn more here.