Discussions

Expand all | Collapse all

Logging Date Field

  • 1.  Logging Date Field

    Posted 09-07-2018 19:03
    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?


  • 2.  RE: Logging Date Field

    Posted 09-07-2018 19:19
    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.


  • 3.  RE: Logging Date Field

    Posted 09-07-2018 19:22
    Just wondering why QB doesn't support enabling logging to Date fields just as with Text fields?_


  • 4.  RE: Logging Date Field

    Posted 09-07-2018 19:31
    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.