hello, can anyone help me with autonumbering of fields

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
Photo of Kristy Williford

Kristy Williford

  • 392 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Did you consider the Record ID# field? It is a great example of an auto generated number.
Photo of Kristy Williford

Kristy Williford

  • 392 Points 250 badge 2x thumb
Yes.But Not helping me unless saved
Why is that a problem?  ie what is the problem of saving and then seeing the Number?
Photo of Kristy Williford

Kristy Williford

  • 392 Points 250 badge 2x thumb
The record id is even considering the deleted records and no starting from the start
If the current record If is at 500, and for some reason you want to start at 1, then you can have a formula of [Record ID#] - 500.

But going forward from now, you are correct that if you allow records to be deleted, then deleted records do use up a number.
(Edited)
Kristy,

Whether it is record id# or any other number, if you want it to be unique, there has to be a guaranteed way of making it unique. Otherwise, if multiple people are using the system at the same time, they may all arrive at the same number. Then it will not be unique anymore.

If you wait until the record is saved, then there is a guarantee that the P# will be unique because the Record ID# is already unique.

There are other ways of arriving at unique numbers, such as based on the time it was created. But if you noticed, even that has to be generated after saving it, otherwise it will not be unique.
Photo of Kristy Williford

Kristy Williford

  • 392 Points 250 badge 2x thumb
hello surya,
Can you please suggest me other ways of auto numbering