Auto numbering

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
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.
Photo of Howard Fu

Howard Fu

  • 294 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
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