Forum Discussion

HowardFu's avatar
HowardFu
Qrew Cadet
7 years ago

Auto numbering

I am attempting to create an auto numbering system. I've read through many of the posts but could not find any discussions that address my issue.

I have a Projects Table with [Project Numbers] and a Project Type Table with [Project Types] being type A, B, C, D, E

I want the project number to be:
if type A ,start at 60000
if type B, start at 90000
if C,D,or E, start at 50000 (this is the part I'm having trouble with)

if the response can show a little detail with the formulas instead of just a general description i would greatly appreciate it.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Auto sequential numbering within different series is truthfully a bit of a pain to set up.

    My first suggestion is to challenge if there is a valid business reason to want them to be sequential within each series. Or is this just "how we always used to do it manually"

    If you simply want them to start at different numbers for each Tyoe, then add say 60,000 to the Record ID if type A, and 90,000 to the Record ID if Type B.

    If no one else takes the time to explain how to do sequential numbering within each series and you would like help setting this up, contact me at QuickBaseCoach.com