Wrong User Shown

Question

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 user who made the edit. I assume because I built the automation. How do I get it to display the actual user name of the person who made the update now that the automation is live.

Note - I cant use a dynamic form rule because edits are done in a grid edit and the grid edit gets around these rules.

Any ideas?

------------------------------
Joshua Case
------------------------------

markshnier__you · Answer

np, sort of.Yes, the Automation Owner will always be the user naming the change and there is no way to change that.&nbsp;But you can change the words being written to the log field to say Equipment Location updated by UserToName([Last Modified by])&nbsp;ie make&nbsp; formula field to calculate the words plus the&nbsp; name of the Last Modified by.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

joshuacase · Answer

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__you · Answer

Yes, your name.m will appear.Course the alternative is to do it right.&nbsp; :)&nbsp;&nbsp;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.&nbsp; &nbsp;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..&nbsp; 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

joshuacase · Answer

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

markshnier__you · Answer

That is correct unless you went through some steps to make a combined text summary field of the child Record to show in a table report. &nbsp;But that would look pretty ugly if there were a lot of updates.Do you need to show them all, or just the most recent update? &nbsp;Showing just the most recent update would be very easy.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Wrong User Shown

Related Content

Can't see what is wrong with this formula using List

Ipad browser issue - Something went wrong?

Gauge Report - Wrong Percentage

Get the role of a user in a user field

Notification to EOTI user