Need to be able to build a custom Auto-increment Column


  • Ok, I need to be able to create a column in a document list that automatically provides a tracking number.  I used the ID column but the client don't like its format (sigh).  So, what I need is something like:

    2012FSP-0001, 2012FSP-0002, etc.

    I have this partly working by using a calculated field with =YEAR(Created)&"FSP-" but how could I get the appended numbers to auto increment?

    Also, this needs to be reset-able (is that word) so that in 2013 it would start at 1 again. 2013FSP-0001, 2013FSP-0002, etc.


    Wednesday, July 11, 2012 4:01 PM

All replies