# RowID is great. Could REALLY use Row Number

**URL:** <https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834>\
**Category:** Feature Requests\
**Created:** [October 6, 2020, 3:34pm UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834 "2020-10-06T15:34:10Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [October 6, 2020, 3:34pm UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/1 "2020-10-06T15:34:10Z")

</div>

Yes, this can be added in Google Sheets…would rather have a native solution. Just a simple 1 through X where X is the number of rows in the table. This would work REALLY well with the Single Value column.

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [October 6, 2020, 3:53pm UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/2 "2020-10-06T15:53:35Z")

</div>

@Robert_Petitto would be very beneficial e.g. when using increment action

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 6, 2020, 3:54pm UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/3 "2020-10-06T15:54:07Z")

</div>

This would be fantastic for paging with increment. I’ve wanted to emulate @Krivo’s image pageing but with less complexity. I do it here, [https://rwtsk.glideapp.io/](https://rwtsk.glideapp.io/) but with some sheet magic.

---

<div class="post-metadata">

**Author:** ![Kyan\_Lynch](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyan_lynch/32/28521_2.png) [@Kyan\_Lynch](https://community.glideapps.com/u/Kyan_Lynch)\
**Post date:** [November 16, 2021, 10:42pm UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/4 "2021-11-16T22:42:33Z")

</div>

I see that Row Numbers have been added to Glide Tables, which is great! Is there anyway to use them in the app, though? I’d like to display the number in the list view, and ideally would like to page forward and back using the numbers.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [November 16, 2021, 11:32pm UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/5 "2021-11-16T23:32:40Z")

</div>

I was hoping for the same thing. @Jason ?

---

<div class="post-metadata">

**Author:** ![Jason](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jason/32/14_2.png) [@Jason](https://community.glideapps.com/u/Jason)\
**Post date:** [November 17, 2021, 1:22am UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/6 "2021-11-17T01:22:00Z")

</div>

How would this work in coordination with say Row Owners?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 17, 2021, 1:37am UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/7 "2021-11-17T01:37:22Z")

</div>

Row numbers would be really useful for the [transpose trick](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [November 17, 2021, 1:39am UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/8 "2021-11-17T01:39:28Z")

</div>

Hm…good point. Dynamic row numbers based on who’s signed in?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 17, 2021, 1:41am UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/9 "2021-11-17T01:41:58Z")

</div>

would you actually want that?  
depends what you’re doing with them, I guess…

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [November 17, 2021, 1:52am UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/10 "2021-11-17T01:52:32Z")

</div>

Ya… no… wouldn’t really want that. Oh well.

---

<div class="post-metadata">

**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\
**Post date:** [November 17, 2021, 7:31am UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/11 "2021-11-17T07:31:29Z")

</div>

Hi Jason, it’s really crucial function to have.

Just have cross-table row numbers. It’s okay that user doesn’t have access(and doesn’t see) e.g.orders #7, 10, 15. Everyone understands that system is used by many users and they create own records.

If business logic requires to keep numbers in secret, it’s okay to continue use Row IDs and don’t use Row Numbers.

But for all my real tasks, Row numbers are required(and I do them with GSheet script and have to deal with delay updating generated numbers back to Glide)

---

<div class="post-metadata">

**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\
**Post date:** [November 17, 2021, 8:19am UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/12 "2021-11-17T08:19:58Z")

</div>

Hi @Jason - I often have the scenario where I need to store where a user has “got to” in a list of “stuff”. For example, to mark all items in a sheet as “read” I would store a timestamp in the user profile and compare this to a timestamp in a sheet row (which lets me effectively mark lots of things as read without the use of user-specific booleans). However when I am working with users in multiple timezones this stops working and I revert to maintaining a computed column for sequence and then storing the last sequence number. It’s pretty horrible. I just want to say “this user got as far as the Nth row”. So row numbers would be super useful in that scenario.

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [January 27, 2022, 9:06pm UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/13 "2022-01-27T21:06:00Z")

</div>

1. RowID column
2. Lookup to gather all rowIDs as an array
3. Find Element Index column…  
Should I continue?)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/8/d851249957851affc63e15531a936479440bb750.png)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 27, 2022, 9:19pm UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/14 "2022-01-27T21:19:13Z")

</div>

Nice. If you were to continue…what more is there to say? 😉

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [January 27, 2022, 9:23pm UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/15 "2022-01-27T21:23:44Z")

</div>

Nothing more, actually) Except I’m on fire (in a good meaning) right now because of finding a solution of one of the most painful Glide questions) No GoogleScript, no formulas, no delay. That just works, thanks to brilliant plugin columns ✨

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [January 28, 2022, 9:23pm UTC](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834/16 "2022-01-28T21:23:46Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
