Sequential numbering of items by bulk edit action

[keith]

For a super in-depth discussion of this in Bubble, see this thread (but start first with the reply post I link to below):

How to achieve Unique, Sequential Numbers Reliably?

A WORD OF WARNING THAT SOME OF THE SOLUTIONS PEOPLE OFFERED ABOVE ARE NOT RELIABLE AND YOU MAY, IN FACT, GET DUPLICATES OR WORSE UNLESS YOU USE THE FOLLOWING METHOD AS - I HAVE TESTED THEM ALL JUST LIKE KEITH DID Not knowing this caused me a lot of issues and setbacks so I hope it saves others. The solution that works perfectly and reliably in bubble natively is the solution buried at the end of Keith’s great video - and all the reasons are explained by him. in summary the soluti…

More recently, I posted an updated solution that is more scalable and performant, here:

How to achieve Unique, Sequential Numbers Reliably?

OK… further to my previous musings… While @morgan’s summary of the correct solution (posted June 2020 above) is still correct, there is in fact a slightly different way to do this that: is likely more much performant for large databases (i.e., when you start to get into huge numbers of orders or whatever it is you are assigning a sequential serial number to) and gets around the issue pointed out by @krzysztof.adamski (here) that :make static seems to crap out on lists that have more than …