Forum Discussion
- Did you consider the Record ID# field? It is a great example of an auto generated number.
- Yes.But Not helping me unless saved
- Why is that a problem? ie what is the problem of saving and then seeing the Number?
- 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.
- 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. - hello surya,
Can you please suggest me other ways of auto numbering
