# Counting number of times signed in / last logged in date
**URL:** https://community.glideapps.com/t/counting-number-of-times-signed-in-last-logged-in-date/28158
**Category:** Ask for Help
**Created:** [June 19, 2021, 6:41pm UTC](https://community.glideapps.com/t/counting-number-of-times-signed-in-last-logged-in-date/28158 "2021-06-19T18:41:00Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@powerupmycourses](https://community.glideapps.com/u/powerupmycourses)
#### Post date: [June 19, 2021, 6:41pm UTC](https://community.glideapps.com/t/counting-number-of-times-signed-in-last-logged-in-date/28158/1 "2021-06-19T18:41:00Z")
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”)
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [June 19, 2021, 6:51pm UTC](https://community.glideapps.com/t/counting-number-of-times-signed-in-last-logged-in-date/28158/2 "2021-06-19T18:51:05Z")
Yes. Just use cointif formula in users sheet to count user emails in login sheet
---
### Author:  [@powerupmycourses](https://community.glideapps.com/u/powerupmycourses)
#### Post date: [June 19, 2021, 6:55pm UTC](https://community.glideapps.com/t/counting-number-of-times-signed-in-last-logged-in-date/28158/3 "2021-06-19T18:55:33Z")
Oh 🤦♂️ I did not realize that was a “log” - do these rows count towards the account limit @Uzo ?
---
### Author:  [@powerupmycourses](https://community.glideapps.com/u/powerupmycourses)
#### Post date: [June 19, 2021, 6:57pm UTC](https://community.glideapps.com/t/counting-number-of-times-signed-in-last-logged-in-date/28158/4 "2021-06-19T18:57:16Z")
I was actually looking to use this in the app - giving them “points” for logging in along with other actions they would take
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [June 19, 2021, 6:58pm UTC](https://community.glideapps.com/t/counting-number-of-times-signed-in-last-logged-in-date/28158/5 "2021-06-19T18:58:32Z")
Only rows in users sheet, log in rows don’t count
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 19, 2021, 7:16pm UTC](https://community.glideapps.com/t/counting-number-of-times-signed-in-last-logged-in-date/28158/6 "2021-06-19T19:16:39Z")
> [@powerupmycourses](#):
>
> I was actually looking to use this in the app - giving them “points” for logging in along with other actions they would take
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
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 19, 2021, 10:10pm UTC](https://community.glideapps.com/t/counting-number-of-times-signed-in-last-logged-in-date/28158/7 "2021-06-19T22:10:29Z")
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 😉
---
### Author:  [@Ricardo\_Limpias](https://community.glideapps.com/u/Ricardo_Limpias)
#### Post date: [May 29, 2023, 1:57pm UTC](https://community.glideapps.com/t/counting-number-of-times-signed-in-last-logged-in-date/28158/8 "2023-05-29T13:57:10Z")
this was a year ago, is there another way right now ?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [May 29, 2023, 2:03pm UTC](https://community.glideapps.com/t/counting-number-of-times-signed-in-last-logged-in-date/28158/9 "2023-05-29T14:03:43Z")
It was actually two years ago 🙂
But no, nothing much has changed here. The approach suggested by @ThinhDinh is still probably the best one.
---
### Author:  [@Mike\_Wrobel](https://community.glideapps.com/u/Mike_Wrobel)
#### Post date: [November 25, 2023, 12:35am UTC](https://community.glideapps.com/t/counting-number-of-times-signed-in-last-logged-in-date/28158/10 "2023-11-25T00:35:40Z")
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
---
### Author:  [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/counting-number-of-times-signed-in-last-logged-in-date/28158/11 "2024-01-17T16:49:09Z")