Does QB store a log of changes?

  • 0
  • 1
  • Question
  • Updated 6 years ago
  • Answered
I need to go back audit changes that have been made to individual records. Does QB log the changes somewhere?
Photo of Ton_loc_fcm

Ton_loc_fcm

  • 0 Points

Posted 7 years ago

  • 0
  • 1
Photo of Mark_Shnier

Mark_Shnier

  • 700 Points 500 badge 2x thumb
No, it does not. If you want to be able to record changes on particular fields, there are ways to do this, but not retroactively.
But the ways require some effort on your end to set this up - its not a cakewalk. Post back if you want more information on how to do this and also the field type(s) on which you are trying to capture the history - text or numeric fields.
Mark
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 6,396 Points 5k badge 2x thumb
You would need to submit a support ticket to take advantage of the Restoration service QuickBase offers as part of their subscription fee, but I do not think this is what you are really looking for.

For the future, there are four main ways you can capture data changes in QuickBase.

1. Create an email account in your company or through gmail; and in each table setup an email notification that will trigger an email notification for all Add/Delete/Modification events in a table. You will need to create a Form in each table that displays ALL the fields so you can see the data as it was in all fields at the time a record was saved. This is the cheapest option.

2. Utilize a logging feature which can be implemented in your tables storing a track of all Logs in your system including if you want, Views of data in your system. The downside to this is that it takes up application space, so you will need to maintain this table of data and either export or delete data periodically.

3. Utilize the QuNect ODBC driver with the Backup Tool that is available to export ALL the data, including the latest or all attchments, into Excel files and folders stored on a local drive. You can run this manually or setup a scheduler to do this automatically.

4. Create a text-append field to capture data changes in each table for specific fields. This is only useful for tracking data changes for specific fields that change where you need a history within the record itself, rather than a history of how the record changed over time.

If you are interested in exploring any of these three options, I can offer you support and demonstrations of all three.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
You can simply redefine the core JavaScript functions QuickBase uses to save a record so in addition to saving the record in the normal fashion the redefined function also saves a copy to a second table. It would work similar to a packet sniffer or a network tap. One copy for you, one copy for me.

It may sound humorous but is actually simple to do. Read about the proxy pattern here:

http://stackoverflow.com/questions/1729501/javascript-overriding-alert
Photo of Ton_loc_fcm

Ton_loc_fcm

  • 0 Points
I have a change notification email set-up, Is there a way to export the information from notifications into a table?
Photo of RacKar

RacKar

  • 0 Points
Hello - I am interested in #4 option above.

This conversation is no longer open for comments or replies.