Can we create auto number while adding data? I use GSheet for Database.
I’m afraid that’s not going to work. If two users or more are using the app at the same time, multi records will have the same number.
This article likely applies:
@Bambang_Christianto - can you clarify if this “auto number” has to be the key, or just a visible sequential number?
If you have another column for the unique key (let’s say you use UNIQUEID() in the Initial Value), then I think you could create another Virtual Column (let’s say call it [number]) with:
Depends if the number is the record key…
Would be ([_ROWNUMBER] - 1)
. ROW() is a spreadsheet function.
You could also try COUNT(MyTable[_ROWNUMBER])
.
oops… mixing topics. Thanks for catching!
Thank you for the Solution, I will try it.
can you clarify if this “auto number” has to be the key, or just a visible sequential number?
YES the Auto Number I will use as the Key.
User | Count |
---|---|
37 | |
25 | |
21 | |
20 | |
16 |