# Count the users email

**URL:** <https://community.glideapps.com/t/count-the-users-email/37779>\
**Category:** Ask for Help\
**Created:** [January 27, 2022, 5:09pm UTC](https://community.glideapps.com/t/count-the-users-email/37779 "2022-01-27T17:09:43Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [January 27, 2022, 5:09pm UTC](https://community.glideapps.com/t/count-the-users-email/37779/1 "2022-01-27T17:09:43Z")

</div>

Hi @Darren_Alderman @ThinhDinh @Robert_Petitto

Have count the users email column.Itsvshowing exactly the total users logged in my app in glide table but displays 1 my app when displayed as text.is it because of row owner in email column?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 27, 2022, 11:46pm UTC](https://community.glideapps.com/t/count-the-users-email/37779/2 "2022-01-27T23:46:47Z")

</div>

If you’re using rollup on top of a table that has row owners, you can only count rows that you can see, since the calculation happens on the device and the device only has access to those rows.

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [January 28, 2022, 3:15pm UTC](https://community.glideapps.com/t/count-the-users-email/37779/3 "2022-01-28T15:15:14Z")

</div>

Can I use the phone number for this,it’s also a unique thing right?

Or else any idea like,comparing the phone number and email like that?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 28, 2022, 11:40pm UTC](https://community.glideapps.com/t/count-the-users-email/37779/4 "2022-01-28T23:40:03Z")

</div>

If you mean using row owners for phone numbers, then no.

What matters is that you’re using row owners, which protects your users’ data, but it also means that they’re only viewing their own rows, so if you want to rollup everything then it’s a no go.

A way to do this is, only if you’re using a Sheet, is using an arrayformula in the Sheet to count the total number of users, then display it in the app.

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [January 29, 2022, 3:07am UTC](https://community.glideapps.com/t/count-the-users-email/37779/5 "2022-01-29T03:07:23Z")

</div>

Yes I’m using sheets.may I know the way of doing this.

---

<div class="post-metadata">

**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\
**Post date:** [January 29, 2022, 6:25am UTC](https://community.glideapps.com/t/count-the-users-email/37779/6 "2022-01-29T06:25:44Z")

</div>

Or you might consider a sign-in step on first use that pushes a name into another Glide Table. You can have a data column in that table and then add a set column in a button that get’s used frequently in your app to set the current time (timestamp). In this way, you have a trip-wire that records usage and you can see who has been on your app recently, sorted by the Timestamp.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 29, 2022, 11:49pm UTC](https://community.glideapps.com/t/count-the-users-email/37779/7 "2022-01-29T23:49:41Z")

</div>

Assuming you store your emails in column A, then the formula would be.

`=ARRAYFORMULA(IF(A2:A<>"",COUNTA($A$2:$A),""))`
