Forum Discussion
Make a child table of Audit Logs for the table you are tracking
Make fields for User (type User) date/time, old value, new value, and field name.
Then have an action that fires where the record is changed and [Field 1 changes]
The action will be to add an audit log record and you will map the values or the old values into the various fields. Be sure to map [Last modified by] into the User field - that is who made the change.
Read up about Actions if you have not used them before. https://help.quickbase.com/user-assistance/creating_a_quickbase_action.html
I've already tested this and it appears to work for what I need so far. The only thing I'm struggling with is the "Then on the audit logging table you would create the same field by formula - the table that the entry was logged from eg "Orders" and the Record ID#"
I might have something mixed up. Take a look below.
Audit Table Screenshot - See Task # field. This is fed by an action from my Task table based on the Record ID in the Task table fed to a text field in the Audit Table. I would like to have a URL Button taking you to that Task # record from Audits to Tasks. Is that what you meant? And Vise Versa between tables.
Formula not working -
URLRoot() & "db/" & [_DBID_TABLE_2] &"?a=er&rid="&[Record ID]&"&dfid=2&tab"
Task Table Screenshot - Report Link, as you can see I'm now showing the audit trail data I need in the record via report link field. However, I do not need the Task # formula button here.
Action Under - Support Tasks Table