0

Record reference numbers

I would like to have a reference number for each of my records that follows onto the next record.

for example my first record is 0001 and I would like the next record to automatically be 0002 and so on.

is this possible?

2 replies

null
    • Fred
    • 4 mths ago
    • Reported - view

    With such a simple reference number, you can just use the Ninox record Id.

    If you create a new formula field you can put:

    Id

    and it will return the record Id.

    Then you can change it with the format() command:

    format(number(Id),"0000")

    You have to also use the number() command to turn the record Id into a basic number.

    • John_Halls
    • 4 mths ago
    • Reported - view

    Hi Gary

    I would also prefix this with a letter or two, so my stock records might be ST001, ST002. I do this so that every record in my database has a unique reference number, as also so that the format in exports to Excel is preserved.

    Regards John

Login to reply

Content aside

  • 4 mths agoLast active
  • 2Replies
  • 41Views
  • 3 Following