need to create field that will auto increment an 8 digit number (or 9 or 10) by 1 each time a new record is added.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
We are entering orders into the app but need each item entered to have a unique 8 digit (or more) number associated with it at creation, this field isnt editable after. What is the simplest way to create this?
Photo of Troy

Troy

  • 0 Points

Posted 3 years ago

  • 0
  • 1
You could have a field called Order# which is the formula

10000000 + [Record ID#]

 so it would read like 10000123

for [Record ID#] = 123

When you get up to your 100 millionth order it will be 9 digits.  At that point you will have been bought out by Google or Apple, as to do 100 million orders you must be on a heck of a growth curve. 
Photo of Troy

Troy

  • 0 Points
Perfect! thank you worked like a charm