Frequency of use data

Let me know if you need any examples, I could probably put a demo together pretty quickly.
@Max_Shepherd I decided to give it a try and have a working demo of this using the above strategy.

My setup in brief:

  • Sheets: On the standard users tab i have a column called “Daily Checkin Complete” as well as a column called “Checkin Tally” (make sure this tab has row owners)
  • Sheets, AppScript: A function called “sumTally” which when triggered (see next point) will go down the list of users and add 1 to the current Tally column if the checkin column is non-zero
  • Sheets, AppScripts, Installable Trigger: A trigger which runs sometime between 12am and 1am which runs the above function daily
  • In Glide Designer: Change the visibility of all existing tabs to only display when the checkin column is non-zero (or 1)
  • In Glide: Create your “Splash Page” with whatever content you want which also has an “Enter” button (I used enter to simulate a fresh “login” to the app, but you of course can make it say anything). Set this button to increment the Checkin column by 1 when clicked.

This should give you an ongoing tally of number of days all users have logged in. Of course both the script and the columns in the users sheet could be modified to create more granular metrics than total number of logins if desired.

As I do have a working demo please let me know if you need a hand getting it to work!

1 Like