# Record counter
**URL:** https://community.glideapps.com/t/record-counter/70985
**Category:** Ask for Help
**Created:** [February 20, 2024, 6:46am UTC](https://community.glideapps.com/t/record-counter/70985 "2024-02-20T06:46:53Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@Tre\_Guerrero](https://community.glideapps.com/u/Tre_Guerrero)
#### Post date: [February 20, 2024, 6:46am UTC](https://community.glideapps.com/t/record-counter/70985/1 "2024-02-20T06:46:53Z")
Hi,
I am not sure if I am using this forum correctly but I found this post and it is exactly what I am trying to do:
> [@Is there something like a record counter?](https://community.glideapps.com/t/is-there-something-like-a-record-counter/39565):
>
> Is there something like a record counter? Let me try to explain this. Right now I have a sheet/table where I have a field with a date. This is the date of entry. I have some columns in which I count the last 7 days and use the values of that date in a template, so I can use it for Quickchart. This works great if every day I input a new record with a date and a value. But now I was thinking, how about if I skip one or two days, then the counting of the last 7 entries is not working. So I w…
However, the video will not play to show the solution I am looking for. Is there another link for this video or can someone type out what is going on in the video?
Thanks
---
### Author:  [@Tre\_Guerrero](https://community.glideapps.com/u/Tre_Guerrero)
#### Post date: [February 20, 2024, 6:47am UTC](https://community.glideapps.com/t/record-counter/70985/2 "2024-02-20T06:47:29Z")
The video was posted by @Darren_Murphy
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 20, 2024, 7:55am UTC](https://community.glideapps.com/t/record-counter/70985/3 "2024-02-20T07:55:24Z")
Try the one below:
> [@How do I create an auto-incrementing row number with Glide Tables?](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572):
>
> This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…
---
### Author:  [@Tre\_Guerrero](https://community.glideapps.com/u/Tre_Guerrero)
#### Post date: [February 20, 2024, 6:38pm UTC](https://community.glideapps.com/t/record-counter/70985/4 "2024-02-20T18:38:21Z")
yes it works. thanks!
---
### Author:  [@Tre\_Guerrero](https://community.glideapps.com/u/Tre_Guerrero)
#### Post date: [February 20, 2024, 6:47pm UTC](https://community.glideapps.com/t/record-counter/70985/5 "2024-02-20T18:47:46Z")
is there a way to have the counter start over based on the row owner? I would like to have separate counters for separate users
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 20, 2024, 7:02pm UTC](https://community.glideapps.com/t/record-counter/70985/6 "2024-02-20T19:02:01Z")
Which method did you end up using?
---
### Author:  [@Tre\_Guerrero](https://community.glideapps.com/u/Tre_Guerrero)
#### Post date: [February 20, 2024, 7:15pm UTC](https://community.glideapps.com/t/record-counter/70985/7 "2024-02-20T19:15:29Z")
I ended up using use case 2 that @Darren_Murphy provided.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 20, 2024, 7:37pm UTC](https://community.glideapps.com/t/record-counter/70985/8 "2024-02-20T19:37:19Z")
Ok. So one option is to apply Row Owners to the table. That way all of the logic will only have access to the rows owned by the signed in user, and all the counts should automatically be unique to each user.
Another method is to create a Query column that filters rows where the email in the row is equal to the This Row → Email. Then point your lookup column to the query instead of the table and everything else should work automatically.
---
### Author:  [@Tre\_Guerrero](https://community.glideapps.com/u/Tre_Guerrero)
#### Post date: [February 20, 2024, 8:31pm UTC](https://community.glideapps.com/t/record-counter/70985/9 "2024-02-20T20:31:15Z")
So I tried row owners and it still counts up regardless of who is the active user. Example:
User 1: 0
User 1: 1
User 1: 2
User 2: 3
User 2: 4
User 2: 5
Where the expected out come should be:
User 1: 0
User 1: 1
User 1: 2
User 2: 0
User 2: 1
User 2: 2
For your second use case. I made a query column that filters by “email is This row → email” then I have another column that did a look up on this query column for “email” and it just returned the emails. Not a counter.
Am I doing something wrong?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 20, 2024, 8:38pm UTC](https://community.glideapps.com/t/record-counter/70985/10 "2024-02-20T20:38:35Z")
> [@Tre\_Guerrero](#):
>
> So I tried row owners and it still counts up regardless of who is the active user.
Have you tried in the published app or the front end of the the app in the builder? The data editor doesn’t fully respect row ownership because it still shows all data whether or not you own it.
> [@Tre\_Guerrero](#):
>
> then I have another column that did a look up
You should have been able to use your existing lookup and point it to the query column. Shouldn’t the lookup column return RowID’s instead of emails??? The process should be exactly the same as option 2 from Darren’s video, but with the addition of the query column and changing the existing lookup column to use the Query. Assuming you had everything else configured for the counts, it should have just picked up and worked with those two small changes.
---
### Author:  [@Tre\_Guerrero](https://community.glideapps.com/u/Tre_Guerrero)
#### Post date: [February 20, 2024, 8:57pm UTC](https://community.glideapps.com/t/record-counter/70985/11 "2024-02-20T20:57:12Z")
Oh yes I didn’t have it pointing to row ID. But your second use case using the query column works and shows in the data editor. Thanks!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [February 27, 2024, 8:58pm UTC](https://community.glideapps.com/t/record-counter/70985/12 "2024-02-27T20:58:08Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.