Record counter

[Tre_Guerrero]

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?

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

[Tre_Guerrero]

The video was posted by @Darren_Murphy

[Darren_Murphy]

Try the one below:

How do I create an auto-incrementing row number with Glide Tables?

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…

[Tre_Guerrero]

yes it works. thanks!

[Tre_Guerrero]

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

[Jeff_Hager]

Which method did you end up using?

[Tre_Guerrero]

I ended up using use case 2 that @Darren_Murphy provided.

[Jeff_Hager]

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.

[Tre_Guerrero]

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?

[Jeff_Hager]

@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.

[Tre_Guerrero]

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!