Is there anyway to count the number of times the person signed into the app (Public App)? I see the App: Logins tab is created (assuming the “Time” is last login? or “Date created”)
Yes. Just use cointif formula in users sheet to count user emails in login sheet
Oh I did not realize that was a “log” - do these rows count towards the account limit @Uzo ?
I was actually looking to use this in the app - giving them “points” for logging in along with other actions they would take
Only rows in users sheet, log in rows don’t count
You won’t find App: logins in Glide, but if you want to use the data in your app you can make a copy of the sheet using a query or similar formula. Couple of things to be aware of though…
- although App:logins doesn’t count towards your row limit, if you make a copy of it and use it then all rows in the copy will count
- it only shows actual logins. If a user just closes the app and opens it again a day (or a week) later, they’ll usually still be signed in, and so you won’t see a new login row
Another approach is to make a button, let’s say “Check in for today” that the user can only click once daily to increment a counter column, it’s not perfect but if we want to give out awards then I think it’s ok to do it that way
this was a year ago, is there another way right now ?
It was actually two years ago
But no, nothing much has changed here. The approach suggested by @ThinhDinh is still probably the best one.
Still not really 100% relevant because as was pointed out by Darren, it only counts a login when there is a login. But I used a query of the App: Logins sheet to get the last login date and total number of logins.
=query(‘App: Logins’!A1:B13,“SELECT MAX(A), B, COUNT(A) WHERE A<>‘’ GROUP BY B LABEL MAX(A)‘Last Login’,COUNT(A)‘Number of Logins’”,1)
That will give you that at least