trying to create a job number generator
OK so we're using Qbase for sales, so we track customers w/ "opportunities". Each customer can have multiple opportunities. For the purposes of production, we use a job number that, for now, we man...
Forum Discussion
Truthfully, I have been down this road before interms of numbering sequentially within a year.
imho and based on a lot of experience "the juice ain't worth the squeeze".
It's a pain to get that setup and hence I suggest that you simply make a formula field to take the last 2 digits of the year of the [Date Created] and then a dash and then use the Record ID#. I will bet that you number jobs internally in sequence within a year just because you have always done it that way and it was a useful way at one time to have unique numbers.
List ("-", Right(ToText(Year(ToDate([Date Created]))),2), ToText([Record ID#]))
imho and based on a lot of experience "the juice ain't worth the squeeze".
It's a pain to get that setup and hence I suggest that you simply make a formula field to take the last 2 digits of the year of the [Date Created] and then a dash and then use the Record ID#. I will bet that you number jobs internally in sequence within a year just because you have always done it that way and it was a useful way at one time to have unique numbers.
List ("-", Right(ToText(Year(ToDate([Date Created]))),2), ToText([Record ID#]))