Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago

Audit Log table of which User deleted a record.

I know how to make an Automation or a Pipeline to create an Audit Log of changes to records and which user made the change. 

But is there a way to capture which user deleted a record?  The [Last Modified by] remains as the "Last Modified by" and not which User did the deletion.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • Probably not the best solution, but perhaps you could remove the rights for people to delete, then create a 'Delete this record' button that triggers a pipeline to delete the record. As part of the button push or pipeline, you could record the current user.

    ------------------------------
    Mike Tamoush
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      Yes, that will likely have to be my Plan B.  I will likely end up there.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • MichaelTamoush's avatar
        MichaelTamoush
        Qrew Captain
        I imagined you had already thought of that, since you taught me that type of thing lol.

        ------------------------------
        Mike Tamoush
        ------------------------------
    • DonLarson's avatar
      DonLarson
      Qrew Elite
      Mike,

      I took this a step further and built a Delete Application for certain records.   The very limited group of User that can delete have to put in the RID they want to have deleted.  There is some logic that checks for child records and will approve or prohibit the deletion.   This app then has the history of all the requests to delete a given record.  Obviously I now have the Date Created and Record Owner for the delete request.


      ------------------------------
      Don Larson
      Paasporter
      Westlake OH
      ------------------------------