Quick Base Discussions

Expand all | Collapse all

Is there a way to show how many times a record has been updated/modified by user?

  • 1.  Is there a way to show how many times a record has been updated/modified by user?

    Posted 04-24-2017 19:43
    I am trying to generate a report that I can select the date and the user and show all records within that date range. In addition, I want to show how many times that user has updated/modified the record. Are there any solutions out there? Thanks so much!


  • 2.  RE: Is there a way to show how many times a record has been updated/modified by user?

    Top
    Contributor
    Posted 04-24-2017 19:49
    Are you trying to watch for any/all changes?  Or, is there one field in particular that you are looking to track? i.e. a Status change, or a date change, etc.


  • 3.  RE: Is there a way to show how many times a record has been updated/modified by user?

    Posted 04-24-2017 19:53
    Any/All changes. Thanks


  • 4.  RE: Is there a way to show how many times a record has been updated/modified by user?

    Top
    Contributor
    Posted 04-24-2017 19:59
    If you want to log any and all changes, you are going to have to create a "Modified Log" table.

    Then use the new "QuickBase Actions" functionality to create a record every time the main record changes.

    You will have to re-create all the fields that you want to track, and then format the 'Action' to copy all those fields to the new record.

    Honestly, its a bit nasty, and might not be worth it.  You can also do this with script to create the log records.

    If you wanted to just target the changes to just a few fields, I'd recommend a simpler version of the "Log" table, to just pay attention to the key fields.
    You could even make those changes a smaller table, and allow a button push to create those changes.


  • 5.  RE: Is there a way to show how many times a record has been updated/modified by user?

    Posted 04-24-2017 20:08
    I figured that. Thanks so much for your help and responses though!