If the records are being edited on forms and not Grid Edit, you can make a new User field called [Real Last Modified by] as well as a formula User field called [Current User].
Then use a Form Rule set to fire all the time (uncheck the checkbox at the bottom)
When the record is saved change [Real Last Modified By] to the value in the field [Current User]. That will give you a field to use in your Automations to know the Real Last Modified by
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 07-01-2020 14:10
From: John Sampath
Subject: How to capture users that have updated a record in one field
I am trying to capture all the users that have updated a record in one field of list user type. Every time a record is updated and saved the field should be appended. It should be straightforward but it is not. What is complicating this is I have multiple automations that are fired when a record is saved. Since I developed these automations , they are updating the last modified by field with my name instead of the user that caused the triggering action. As an end result I am not able to leverage the last modified by field to capture the user name who caused the triggering action. The same holds true if I try using the user() function in a formula. Is there a solution please?
------------------------------
John Sampath
------------------------------