Re: Sequential Numbering System based on multiple factors
Funny you wrote this as we had the same conversation in our office as we are building the functionality, Currently we use a numbering system of year (two digit) plus an incremental number that resets each year. So this year started with 19001, 19002, 19003, etc. At the time it made sense as it gives us a rough timeframe of how old a project is.
As I am developing Quick Base I just used the built in auto number system and a bunch of people have said thats wrong it needs to be in the 19001 format. I asked why.... I got the because that is how we do it answer. I asked why. They said because it gives us a rough estimate of when a project started. I said but Quick Base has that info with a date started field. They said they need it. I said why, havent gotten another answer yet so I know no one can thing of one lol
I too would prefer that format out of habit, but I am using the time to eliminate it and just reset it.
I would be interested though in having a certain number of leading zero's for formatting. I might look into that.
As I am developing Quick Base I just used the built in auto number system and a bunch of people have said thats wrong it needs to be in the 19001 format. I asked why.... I got the because that is how we do it answer. I asked why. They said because it gives us a rough estimate of when a project started. I said but Quick Base has that info with a date started field. They said they need it. I said why, havent gotten another answer yet so I know no one can thing of one lol
I too would prefer that format out of habit, but I am using the time to eliminate it and just reset it.
I would be interested though in having a certain number of leading zero's for formatting. I might look into that.