Skip to Content (Press Enter)
2019-12-11 17-59-12
Nelson André
180Views
2Comments
Set initial ID value of identifier field
Question
Database

Does anyone know if it's possible to define the initial value of the Id field in a new table?

Instead of starting in 1, start in 30 000 for example, and then go 30001, 30002, etc....

Thanks.

0
0
22 Jun 2021
Copy Link
2021-04-17 09-53-48
José Gonçalves

Hi Nelson,

with the AutoNumber property as True I think not. There is no parameter for that.

You can create your own AutoNumber logic.

Regards

1
0
22 Jun 2021
Copy Link
2021-05-18 02-27-17
Manish Gupta
Champion

Hi Nelson 

What Jose has said is absolutely right, with the AutoNumber we cannot manage that but Saying "NO" to AutoNumber OS allowed us to manage the ID. Just for example here I created sample logic to set the ID based on length. 

https://personal-9qwkrkgl.outsystemscloud.com/ForumHelp/Random?_ts=637600351373784850


Please Note: the Logic of length is not valid, it is Just for example. As if someone deleted the entry from middle of records, it will generate the same ID given to last row. But this is only a walkthrough of what could be done


0
0
23 Jun 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.