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
Here you go:
Unique Project Number ~ Add New Record
https://haversineconsulting.quickbase.com/db/bkjugeh48?a=nwr
Pastie Database UPDATED
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=469
Notes
(1) The datejs library is not automatically loaded on the ?a=nwr page so I manually reloaded it from the QuickBase CDN. However, since the URL to the QuickBase CDN has a version number (70087-8) in it this demo will eventually fail when QuickBase deletes the old version of the resourse.
https://quickbase.intuitcdn.net/res/70087-8/js/date.js
(2) I made the [Project Number] field readonly on the add record form so nobody could mess with it. If you needed to fix the [Project Number] you can edit it through grid edit.
Unique Project Number ~ Add New Record
https://haversineconsulting.quickbase.com/db/bkjugeh48?a=nwr
Pastie Database UPDATED
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=469
Notes
(1) The datejs library is not automatically loaded on the ?a=nwr page so I manually reloaded it from the QuickBase CDN. However, since the URL to the QuickBase CDN has a version number (70087-8) in it this demo will eventually fail when QuickBase deletes the old version of the resourse.
https://quickbase.intuitcdn.net/res/70087-8/js/date.js
(2) I made the [Project Number] field readonly on the add record form so nobody could mess with it. If you needed to fix the [Project Number] you can edit it through grid edit.