You can see who in future its better to post one question per post as the questions and responses get all tangled up when there are three separate questions.
The high plan levels of Quick Base has native full audit logging capability on a limited number of important fields in any table.
But if you are not opting for that feature in your plan, then you need to do your own logging. One very low tech solution for a poor man's auto trail is to set up a notification to fire the default email notification into say a gmail account setup for that exclusive purpose. The form will highlight changed in red, but will not tell you the old value, just the new value.
The Custom email Notifications can also be set up using the field name like [old.Scheduled Date] and that will show the old value of the [Scheduled date] field. Again, that can be send into a gmail account to allow searching
The other alternative is to use Automations to write out a child record to the main record to show the changes to specific important fields. So, you need to think though which fields are important to track and how much money you want to spend for the native Audit Logging feature (knowing that it's really designed more as an Audit / compliance tool and not so much to easily expose the history to regular users) or how much effort you want to go to to log key fields. if you want to log changes to key fields in a child table, then we can carry on that discussion on best practices there.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commarkshnier2@gmail.com
------------------------------
