# Is there a way to track how many times someone has logged into app?

**URL:** <https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102>\
**Category:** Ask for Help\
**Created:** [February 4, 2022, 2:58am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102 "2022-02-04T02:58:02Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [February 4, 2022, 2:58am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/1 "2022-02-04T02:58:02Z")

</div>

I’d like to be able to track the volume of use with log ins. I’m guessing there is something obvious in Glide that I just haven’t discovered?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 4, 2022, 2:59am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/2 "2022-02-04T02:59:51Z")

</div>

you should have a logins sheet…  
or create your own

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [February 4, 2022, 3:04am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/3 "2022-02-04T03:04:40Z")

</div>

So I have a sheet with all my users, but i don’t know how often they’ve logged in. What kind of column do I need to add to my database to track it? And I’d attach it to the profile page too I’m guessing?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 4, 2022, 3:06am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/4 "2022-02-04T03:06:56Z")

</div>

if you wanna track logins, it happens automatically in the log-in sheet…  
to track entry to your app… you have to create a button to do that… you have public access or email?

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [February 4, 2022, 3:09am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/5 "2022-02-04T03:09:59Z")

</div>

ok, since mine isn’t tracking automatically then I guess I don’t have a ‘log-in’ sheet. dumb question - how do you set that up then? Its public with real email, pro account.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 4, 2022, 3:11am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/6 "2022-02-04T03:11:07Z")

</div>

did you ever log in to your app? if yes… glide will create a log in sheet automatically

 ![Screen Shot 2022-02-03 at 10.13.02 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c9c5aabc7d8252612a1f34e3274a70a4fc25c4e9.png)

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [February 4, 2022, 3:15am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/7 "2022-02-04T03:15:09Z")

</div>

OOOOHHHHHHH. It’s only on my actual google sheet that I never look at, not in glide. got it. Is there a way to have in show up in their columns in glide so it’s more organized instead of one long list?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 4, 2022, 3:19am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/8 "2022-02-04T03:19:21Z")

</div>

the log-in sheet is hidden in Glide for privacy and security reasons … you can copy that sheet using google formula ={App: Logins!A1:D} and then relate emails to the users sheet

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [February 4, 2022, 3:26am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/9 "2022-02-04T03:26:38Z")

</div>

knowing how and where to use code is far above my knowledge level at this point but i’ll go ahead and save that formula for when I can figure that out someday haha 🙂 thanks

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 4, 2022, 3:28am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/10 "2022-02-04T03:28:28Z")

</div>

open a new sheet in google sheets and paste that formula in A1 cell

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [February 4, 2022, 3:31am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/11 "2022-02-04T03:31:08Z")

</div>

ok i did

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 4, 2022, 3:31am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/12 "2022-02-04T03:31:39Z")

</div>

did it copy your logins sheet?

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [February 4, 2022, 3:34am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/13 "2022-02-04T03:34:03Z")

</div>

No, was I suppose to do something else before that?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d195ad7ce7f3691fda38c72031e58dbc44f03b05.png)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 4, 2022, 3:34am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/14 "2022-02-04T03:34:46Z")

</div>

take out the ’ character before =

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [February 4, 2022, 3:36am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/15 "2022-02-04T03:36:11Z")

</div>

ok now it says this?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94f7c31cc260efbc3ea40d8ef88e4448ab843138.png)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 4, 2022, 3:38am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/16 "2022-02-04T03:38:11Z")

</div>

sorry… typo… copy and paste again this one :

`={'App: Logins'!A:C}`

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [February 4, 2022, 3:39am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/17 "2022-02-04T03:39:36Z")

</div>

ok copied! now what do i do?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [February 4, 2022, 3:40am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/18 "2022-02-04T03:40:22Z")

</div>

what is your goal? to track the date of the last login? or count?

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [February 4, 2022, 3:41am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/19 "2022-02-04T03:41:27Z")

</div>

more frequency; total # of logins from each user

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [February 4, 2022, 3:44am UTC](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102/20 "2022-02-04T03:44:40Z")

</div>

It looks like I could probably just figure out how to organize this sheet better since it puts them all in one huge row

[Next page](https://community.glideapps.com/t/is-there-a-way-to-track-how-many-times-someone-has-logged-into-app/38102.md?page=2)
