Sorry, i dont know how to tell the problems

[Martinus_Goh]

The Problems here is, i set the automatic number everytime a user input/add items, but when multiple user input, it keeps run away the number, like its sometime already on number 320
but the it continues to 24, 64, 57, and sometimes it leaves blank.

i assume that maybe the cache to multiple user still intach to the last number they access
how do i solve it ?

[ThinhDinh]

I assume you’re doing a sequential numbers flow?

Can you attach some screenshots or a video on how you’re setting that up?

[Martinus_Goh]

yep a sequential numbers flow.
and multiple user could add the items
was following the method from mr.Darren

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…

work when i was the only one to input
but when go live with multiple user input, it goes random

[ThinhDinh]

So is it a sequence for the whole table, or do you have parts that you want to sequence “locally”? Say item 1 will have its own sequence, item 2 will have its own as well?