Has anyone discovered a reliable way to do Row Numbers (sequential numbers for each row in a table) inside Glide–meaning not using the Google Sheets method of ARRAYFORMULA and ROW. I’d be fine using this method if I was using Google Sheets, but I’ve moved over to a Glide Tables for a particular ledger where I need considerably more rows than Sheets can handle and no lag. But I need Row Numbers.
@david many months ago there was a brief chat about this in another thread (I tried to find it). You seemed to be questioning whether such a feature was needed, or perhaps how important it was compared to RowID. You asked for use cases. A few folks gave you some, and I said I’d get back to you. Well, tonight I released a feature in my app, using a calculation method to create Row Numbers and it was an absolute fail.
My app has a collectibles feature. My members are collecting limited edition badges… basically NFTs except rather than a Blockchain, it’s a Glide Table. I need to number them. It’s an important part of collectibles. I’m using the following method: I have a Relation bundling up all claimed transactions in the Table of a specific collectible… then I have Rollup counting those up… then I have a Math Column adding 1 to that total (I call that column NextRowNumber). And so when someone claims a collectible, a new transaction is added to that ledger, and it stamps whatever is currently in the NextRowNumber column into a new column called EditionNumber. Then that new transaction increases the Rollup count and the NextRowNumber columns… rinse and repeat.
Should work, right? And it usually does… except when 50 people all attempt to claim the collectible within 20 seconds. Glide doesn’t update columns fast enough, and half of the transactions get stamped with the same Edition#.
Can we please have a RowNumber column? Pretty please? Just like the RowID column–autoupdating–but just sequential numbers. Or has someone come up with a more reliable solution to this?