Discussions

Expand all | Collapse all

hello, can anyone help me with autonumbering of fields

  • 1.  hello, can anyone help me with autonumbering of fields

    Posted 04-29-2019 15:56


  • 2.  RE: hello, can anyone help me with autonumbering of fields

    Posted 04-29-2019 15:58
    Did you consider the Record ID# field? It is a great example of an auto generated number.


  • 3.  RE: hello, can anyone help me with autonumbering of fields

    Posted 04-29-2019 17:26
    Yes.But Not helping me unless saved


  • 4.  RE: hello, can anyone help me with autonumbering of fields

    Posted 04-29-2019 17:56
    Why is that a problem?  ie what is the problem of saving and then seeing the Number?


  • 5.  RE: hello, can anyone help me with autonumbering of fields

    Posted 04-29-2019 22:13
    The record id is even considering the deleted records and no starting from the start


  • 6.  RE: hello, can anyone help me with autonumbering of fields

    Posted 04-29-2019 23:02
    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.


  • 7.  RE: hello, can anyone help me with autonumbering of fields

    Posted 04-29-2019 18:10
    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.


  • 8.  RE: hello, can anyone help me with autonumbering of fields

    Posted 05-01-2019 17:13
    hello surya,
    Can you please suggest me other ways of auto numbering