Logging edits to a record
Is it possible to set up a multi line text field that can log every edit made to a record with the field that was touched, user who did it and a date stamp?
Forum Discussion
My original example used a text multiline field with logging turned on so the user and timestamping was created by QuickBase automatically - the script just gather the old and new values of those fields that changed and stuffed them into the logging field. To log just the last n changes or changes over the last 7 days you would have to use a text multiline field without logging turned on and (1) perform all the user and timestamping yourself in addition to (2) removing "old" changes that become stale and (3) adding "new" changes. It is just more script to write to suit the specific needs of your logging strategy. If you need help contact me off-world using the info in my profile.