Discussions

Expand all | Collapse all

Wrong User Shown

  • 1.  Wrong User Shown

    Posted 17 days ago
      |   view attached
    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
    ------------------------------


  • 2.  RE: Wrong User Shown

    Posted 17 days ago
    np, 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
    ------------------------------



  • 3.  RE: Wrong User Shown

    Posted 17 days ago
    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
    ------------------------------



  • 4.  RE: Wrong User Shown

    Posted 17 days ago
    Yes, 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
    ------------------------------



  • 5.  RE: Wrong User Shown

    Posted 16 days ago
    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
    ------------------------------



  • 6.  RE: Wrong User Shown

    Posted 16 days ago
    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.  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?  Showing just the most recent update would be very easy.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------