How can I determine the applications in my realm which have had more than 100 entries in a week?

Can you define what an "entry" is? Is it records created, records modified, records deleted, all of the above as a total? And when you say "applications", do you literally mean that or just tables? If you mean applications, which tables in each should be used to determine the entries, or should it be based across all tables within an app totaled together?

Hello Michael, entries would be records modified. Yes, by applications I mean any record in an application if modified, I want to track that. I need to have the visibility of applications where they are modified  more than 100 times a week. It is not specific to any particular table, just the application in general. 

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-webhooks

https://community.quickbase.com/quickbase/topics/does-qb-store-a-log-of-changes

https://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-field

In addition, you might go here and search for: log of changes
https://community.quickbase.com/quickbase/topics/search/show

I 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.
 

I can think of two different ways to do this:

1) Script

You could iterate through all of your applications and tables using API_GrantedDBs and for each perform a query that will return or count those records created in the last week. What query you perform depends on the state of your applications as you may not have a known apptoken to use against all applications. Also this process could generate a lot of API calls which could be expensive if it ran too frequently, take long time or even grind your browser to a halt.

2) Service Worker

You could also implement a Service Worker that silently monitored every network request and counted or logged all requests of a particular type.  This approach could only work for Chrome, Firefox, and Opera browsers as we are waiting for Service Workers to land in Edge and Safari.