Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
OK, so a no code native solution
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
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