Discussions

 View Only
  • 1.  Audit Log table of which User deleted a record.

    Posted 07-30-2021 18:44
    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
    ------------------------------


  • 2.  RE: Audit Log table of which User deleted a record.

    Posted 07-30-2021 19:55
    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
    ------------------------------



  • 3.  RE: Audit Log table of which User deleted a record.

    Posted 07-30-2021 19:56
    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
    ------------------------------



  • 4.  RE: Audit Log table of which User deleted a record.

    Posted 07-30-2021 20:00
    I imagined you had already thought of that, since you taught me that type of thing lol.

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 5.  RE: Audit Log table of which User deleted a record.

    Posted 08-02-2021 11:09
    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
    ------------------------------