Need to be able to build a custom Auto-increment Column
-
Wednesday, July 11, 2012 4:01 PM
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.
Thx
All Replies
-
Wednesday, July 11, 2012 4:37 PM
You can use a designer workflow to update the field using ID column value.
Alternatively, refer to the following blog as well
--Cheers
- Edited by Prasath C Wednesday, July 11, 2012 4:40 PM
-
Wednesday, July 11, 2012 5:14 PMWow, its crazy to have to go through so many hoops. Is there no simple, straightforward way, this seems like a no-brainer?
.png)
