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
This can also be done without script. I have done this for s few clients. They are always a bit finicky to get working.
The technique would be to create a table where the Key field is set to YY-MM and loaded up via Excel for say the next 10 years, so like
16-01
16-02
16-03
Then make a similar field in your project table by formula. You should be able to base it off the [Date Created] field.
Then make a relationship and do a Summary of the # of Projects.
The magic technique is then to lookup that Summary Total down to the Projects table and lastly to make a snapshot field of that lookup. That will be your frozen count for the YY-MM.
Then you create a text formula field to make the YY-MM-SSS strung that you want.
The technique would be to create a table where the Key field is set to YY-MM and loaded up via Excel for say the next 10 years, so like
16-01
16-02
16-03
Then make a similar field in your project table by formula. You should be able to base it off the [Date Created] field.
Then make a relationship and do a Summary of the # of Projects.
The magic technique is then to lookup that Summary Total down to the Projects table and lastly to make a snapshot field of that lookup. That will be your frozen count for the YY-MM.
Then you create a text formula field to make the YY-MM-SSS strung that you want.