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
I had a similar issue and resolved it by using the following formula:
[Related OEM2 - Quote Prefix]&Year(ToDate([Date Created]))&[Record ID#]
I used an OEM prefix (from a separate table), current year (which is 2018) and the record ID # to solve the issue. I hope this helps.
[Related OEM2 - Quote Prefix]&Year(ToDate([Date Created]))&[Record ID#]
I used an OEM prefix (from a separate table), current year (which is 2018) and the record ID # to solve the issue. I hope this helps.