Yes, you are correct. The automation is the culprit. When an automation runs, it runs under the owners name (of the automation) which is yourself. Since the automation is modifying the record, boom, you are now the last modified by.
I am not sure if there is a way to actually update the 'Last Modified by' field, but you can capture the last modified by creating a new text field [Last Modified By Manual] (or something) and as part of the automation, set [Last Modified By Manual] to the [Last Modified By Field].
I believe since Last Modified By is an intrinsic field, you cannot overwrite it, but perhaps someone else will know otherwise.
------------------------------
Mike Tamoush
------------------------------
Original Message:
Sent: 11-24-2021 10:12
From: William Wallace
Subject: Last Modified By field capturing wrong user name
I'm baffled, I set up an automation on a table to add a record when a record in another table gets modified. The record is added but it has my name instead of the person who modified the original record. How do I capture the person's name who modified the record instead of mine? (person who created the app).
Example: Record is Table 1 is edited by a user, (Last Edited By: captures My Name) / Table 2 adds the record which was edited, but has (Last Edited By: My Name) instead of user who edited record in Table 1, which is what I want to capture.
I think the automation is the culprit, but not quite sure.
Thanks for any input!
------------------------------
William Wallace
Fleet Operations Specialist
Motional
------------------------------