Discussions

Expand all | Collapse all

Tracking Changes

  • 1.  Tracking Changes

    Posted 23 days ago
    I searched prior discussions before posting this, so I apologize if it's a duplication.  If it is just refer me to the prior article.  Anyhow, I have a table with 45 fields, any of which could change.  I'd like to keep an audit trail of changes to records for any of the previously mentioned fields.  

    How would I set it up so I can bring awareness to which field changed and perhaps what the old value was and now the new value?  I want my clients to be able to pull reports of any changes based on a particular record ID.

    Thanks,

    ------------------------------
    Michael Sargent
    ------------------------------


  • 2.  RE: Tracking Changes

    Posted 23 days ago
    I could work with you one on one if you like to get this set up.
    One solution is to have an Automation fire with 45 steps to record the before and after values for all the fields into a child log table of changes.  Then the last step #46 will be to delete all the records where there was no change.​

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



  • 3.  RE: Tracking Changes

    Posted 22 days ago
    Are you just looking to track changes?  If so, a change log is an easy solution.

    ------------------------------
    Paul Peterson
    ------------------------------