Logging Date Field

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
I have searched previous threads for how to log edits to a date field, but those threads are like 2 yrs old now. So I am wondering if there is a better and easier solution available now?
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Slider

Slider

  • 1,346 Points 1k badge 2x thumb
Quick Base is releasing audit logging. It is an additional cost and only retains logs for a certain period of time.

Appending fields are great for logging entries over time. Using these types of fields in conjunction with form rules is normally a good method for logging edits.

I have used Actions (may also use automations) to log changes to a field to a change log table. These changes over time are logged in a table, and can be surfaced via reporting. This method is great for analytics. 

We also use some scripts to log changes in an application to a change log table, we call it advanced change logging. It can capture specific Table/Field changes and more.
Photo of William Latimer

William Latimer

  • 396 Points 250 badge 2x thumb
Just wondering why QB doesn't support enabling logging to Date fields just as with Text fields?
Photo of Slider

Slider

  • 1,346 Points 1k badge 2x thumb
thats a good suggestion. I wonder why they do not. If the data entry is on a form, you can write the value of that date field to an append text field. if the data entry occurs via api or multi record operations, then you need an alternative method.