Create a field that can log changes made to the record

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • In Progress
In 2017 QuickBase Empower, someone showed me how they are recording all the changes made to the record in a text field. It logs username, time, changed made etc.

How can we build this field? 
Photo of AZ

AZ

  • 40 Points

Posted 9 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
I'd make a bet that they are utilizing an 'action' to watch for when things are changed.  Then writing the user, data/time to normal fields on the records.

Or you could create child records based on that change as well.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,332 Points 20k badge 2x thumb
Changes originate in the browser so there is no good reason to create an action. This demo introduced the idea of detecting changes to various fields through script on the new/edit form and appending a short message to the text logging filed. You can make your own changes to records and see them logged after you save the form.

Come Mr Tally Man Tally Me Banana
https://haversineconsulting.quickbase.com/db/bi5q4vzj9

Pastie Databse
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=305