What is the best practice for auto numbering?

Singh3
Tera Contributor

‎01-29-2024 06:16 AM

Hello people,
I wanted to ask a question about auto numbering and what the best approach would be?
I have a use case in which I want to have auto numbering enabled in different tables (HR case, knowledge etc.), but when a new form is loaded, the system should auto number to the next possible number (For eg. if there are 4 records inserted as 1,2,3,4 - next number should be 5). The tables also have integration data syncd for which a job would be running every week, but the numbers are not in sync, so the numbers could be higher as well. The padded system does not work perfectly, so I have created a script include which I can call in default value of the number field. The other solution revolves around having a BR - before insert and an on load client script. But, the default solution is not very upgrade friendly and the Br and client script would need to be created on every table we want this to work on.
Could anyone please let me know if there is another approach which I might be missing?
Thanks

0 Helpfuls
  • 938 Views
1 REPLY 1