Dear Community: I need your help. I need to c...

data
(SmartD) #1

Dear Community: I need your help. I need to create a numeric field (not a key) that sequentially increments a unit each time a record is generated. Could someone help me with an idea? Thanks in advance

(Aleksi Alkio) #2

Have you read about it from this article? help.appsheet.com - Sequential Keys Sequential Keys help.appsheet.com

(SmartD) #3

@Aleksi_Alkio

Hello Aleksi, I read the article. In my case I want to assign a range of numbers to each of the 6 users I have, so there are no problems with the sequential increase. For example, - User one will have the range of 10000001 up to 1999.9999 - User two will have the range of 20000001 to 29999999 Is it possible to work in this way. Thanks in advance.

(Aleksi Alkio) #4

Yes it’s possible.You just need to read the max number for that user from your existing table and then + 1.

(SmartD) #5

@Aleksi_Alkio I will try your solution. Thank you !