Skip to main content (Press Enter).
Skip auxiliary navigation (Press Enter).
Quick Base University
Skip main navigation (Press Enter).
on this day
between these dates
Back to discussions
sort by most recent
sort by thread
I am attempting to create an auto numbering system. I've read through many of the posts but could no...
Auto sequential numbering within different series is truthfully a bit of a pain to set up. My f...
Posted 02-07-2019 22:33
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.
RE: Auto numbering
Posted 02-08-2019 04:04
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
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Powered by Higher Logic