I came to QuickBase from the Salesforce world, and they had a very nice, built-in change log feature that would let me see when and by whom a record was created, along with specifying important fields within each record and when and by whom they were modified (and what values they were modified from and to). There isn't too much I miss about SF, but this is something that QB doesn't do natively (and should!).
That said, I have not yet implemented a change log in my QB app, but I have been collecting and studying resources. Here are a couple of good links for you to read:
https://community.quickbase.com/quickbase/topics/is-there-a-way-to-show-how-many-times-a-record-has-...https://community.quickbase.com/quickbase/topics/creating-a-change-log-using-webhookshttps://community.quickbase.com/quickbase/topics/does-qb-store-a-log-of-changeshttps://community.quickbase.com/quickbase/topics/is-it-possible-to-create-a-field-that-will-log-edit...https://community.quickbase.com/quickbase/topics/change-log-for-a-related-fieldIn addition, you might go here and search for: log of changes
https://community.quickbase.com/quickbase/topics/search/showI personally like the Gmail option that was mentioned by Mark in one of these threads. I will probably do that when I get around to it.
Since you need counts within a date range, you will most likely need to create a ChangeLog table and write out records to it using actions or webhooks and store fields for:
date/time
user
application
table
action (add, change, delete)
field changed
field before value
field after value
The pain with doing this is that you literally have to set up this for each table and each field that you want to track. Straightforward to do, but time-consuming. And then you need to keep it up as you change and add apps, tables and fields. It's overhead. Is it worth it?
Perhaps you could take a look at your apps and tables and look for some important indicator tables and fields and just set it up for those to serve as a proxy to get overall totals on usage stats.
