How can I determine the applications in my realm which have had more than 100 entries in a week?
For inventory management I need to find the applications which have more than 100 entries by its users in a given week. Can anyone suggest me a way to accomplish this?
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!).
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.
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.
Thanks Michael, I have a lot of applications (hundreds) so I don't think creating a change log for each table is worth the time. Also, I need to monitor the applications in my realm which change in anyway so I can track which applications are used more. I think I need to find a better way to do so.
Why do you have so many separate apps? I think it ends up being much harder to manage that way. I have a single app with 75+ tables. Everything ultimately needs to tie together.
Well, we have client facing apps for specific purposes. Thanks for sharing the articles. I'll definitely look into them and see if I can track important apps.
You can secure anything within a single, large app so that only a small subset is exposed to clients or any other role. Good luck with your project!
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.
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.
Hello Dan, the service worker option looks good. Can you please elaborate on how to accomplish the task using service worker?
You would have to decide which URLs indicate activity in the database and increment a counter and save the result back to the log table. In the above example all URLs visited were logged in the log table. In your case you would be logging a counter after it was increment in the log table.