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
------------------------------
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
------------------------------
