How do I create a unique project number?
I?m creating a project number tracking app which uses a unique project number. The project number format is YY-MM-SSS, where YY is the current year, MM is the current month, and SSS is a sequenti...
Forum Discussion
You have to use script to do this. Here is the code (untested):
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=469
I am about to travel but if I get a chance I will make a working demo out of it when I get back.
Notes
(1) QuickBase has the datejs library loaded on the page so we can easily manipulate dates. See:
http://www.datejs.com/
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=469
I am about to travel but if I get a chance I will make a working demo out of it when I get back.
Notes
(1) QuickBase has the datejs library loaded on the page so we can easily manipulate dates. See:
http://www.datejs.com/