Wrong User Shown
I have an automation built to display changes from a drop down in a text field that logs edits with a username and timestamp for all changes. When the automation runs it always shows my name as the u...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp, sort of.
Yes, the Automation Owner will always be the user naming the change and there is no way to change that.
But you can change the words being written to the log field to say Equipment Location updated by UserToName([Last Modified by])
ie make formula field to calculate the words plus the name of the Last Modified by.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Yes, the Automation Owner will always be the user naming the change and there is no way to change that.
But you can change the words being written to the log field to say Equipment Location updated by UserToName([Last Modified by])
ie make formula field to calculate the words plus the name of the Last Modified by.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- And just to confirm my name will still be part of the time stamp with this method correct?
I could then just adjust the time stamp to be the date.
------------------------------
Joshua Case
------------------------------- MarkShnier__YouYes, your name.m will appear.
Course the alternative is to do it right. :)
Really the right way given that you're using an automation is to create a child table and properly write the records into a child adit log table. Another advantage of that method as you can write the updates from several different fields into the same audit log and in the audit log table you would identify a field being updated you can also write the old value and the new value into two separate columns (fields) in the audit log table.. Then you can totally control what the fields are being written and you would write the [last modified by] of the main record into the the audit log record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- With this method you describe you would have to have an embedded report in the form displaying the audit log changes from the child table but you couldnt display that audit log in the table report on the parent table correct?
------------------------------
Joshua Case
------------------------------
