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. T…

For this use case, I think the Row Index method is the simplest approach.

this is very simple… create a number column, call it counter… add another column rollup maximum value from counter column add another math column call it max counter plus 1… and the function will be rollup maximum + 1, now every time you make a new record, set the counter column with the value fro…

@Uzo , thanks but it is only working half. I have created the number column and called it counter Then I created the rollup column and called it RollupMax and pointed it to the counter column Then I created the math column and called it “Counter+1” In there, for the configuration, I had put “coun…

I see that you did not follow my instruction precisely, your mistake is that you should add 1 to the rollup max column not to counter… change that and it will work well… column Counter+1 should have all numbers the same.

Try something like this: [image] open_mailbox_with_raised_flag Create a Referral Code System with CUSTOM and UNIQUE User Codes Community Resources wave Hey all! In this video, I demonstrate how to generate short, pretty and unique codes per user to be used as I…

this is great! I did not think of it. how did you come up with that… very clever! [Screen Shot 2022-03-12 at 9.13.15 PM] Thanks for sharing! @Darren_Murphy , now I can do webhooks directly from glide without waiting for glide to write the value in GS! Wow… my Apps gonna be so fast!

Thanks, but I can’t take credit. It was @11183 that came up with the idea. And yeah, it’s a great technique - I’ve already found many many uses for it.

Thanks @Darren_Murphy This works :slightly_smiling_face: There is no problem later when the column “AllRowIDs” is getting too big? I mean, that there are too many RowIDs in the array?

good point… depends on how they store joined data

I think I’ve seen Jason mention a character limit. I can’t recall what it is, but it’s something crazy like billions (maybe trillions?) of characters. Probably not something you have to worry about :wink: Keep in mind also that this is computed data, so it doesn’t actually impact the “size” of your…

Thanks Good to know :slightly_smiling_face:

Is there something like a record counter?

Ask for Help

Robert_Petitto March 12, 2022, 11:22pm 5

Try something like this:

Topic		Replies	Views
Record counter Ask for Help	11	261	February 20, 2024
How to increment a number counter field? Ask for Help	42	5938	January 1, 2022
Auto Numbering Ask for Help	58	7757	April 18, 2025
Countif in Glide Table Ask for Help	16	1104	April 25, 2022
Increment + GSheets Ask for Help	11	674	November 22, 2022

Is there something like a record counter?

Related topics