Expand all | Collapse all

Auto numbering

  • 1.  Auto numbering

    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.

  • 2.  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