Answered by:
auto-incremented list columns

Question
-
I want like to hakve a column/field which would have a auto-increamented value.
Typically ID in a list comes with the incremented number but its in the range from 1, 2, 3......n
Could you please let me know what is the maximum number ID can accomodate.
But i want to know, if we could actually have somehing like 0001, 0002,.....,0010,0011,..9999
Is there a way to create a calculated column which includes ID column from the list to make 1 to 0001.
Thanks
Monday, September 22, 2014 3:25 PM
Answers
-
Yes, you have 3 options for this
1. Calculated column,
2. SPD
3. Event receiver.Refer to the following post for more information
http://sharepoint.stackexchange.com/questions/76249/autoincrement-a-field-based-on-id
- Marked as answer by Victoria Xia Tuesday, September 30, 2014 9:29 AM
Monday, September 22, 2014 3:51 PM -
Try below:
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_27204004.html
http://dlairman.wordpress.com/2011/01/10/add-a-unique-auto-incrementing-column-to-a-sharepoint-list/
https://www.nothingbutsharepoint.com/sites/eusp/pages/sharepoint-how-to-create-an-auto-incrementing-number-field-for-use-in-a-custom-id-part-1.aspx
If this helped you resolve your issue, please mark it Answered
- Marked as answer by Victoria Xia Tuesday, September 30, 2014 9:29 AM
Monday, September 22, 2014 4:00 PM
All replies
-
Yes, you have 3 options for this
1. Calculated column,
2. SPD
3. Event receiver.Refer to the following post for more information
http://sharepoint.stackexchange.com/questions/76249/autoincrement-a-field-based-on-id
- Marked as answer by Victoria Xia Tuesday, September 30, 2014 9:29 AM
Monday, September 22, 2014 3:51 PM -
Try below:
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_27204004.html
http://dlairman.wordpress.com/2011/01/10/add-a-unique-auto-incrementing-column-to-a-sharepoint-list/
https://www.nothingbutsharepoint.com/sites/eusp/pages/sharepoint-how-to-create-an-auto-incrementing-number-field-for-use-in-a-custom-id-part-1.aspx
If this helped you resolve your issue, please mark it Answered
- Marked as answer by Victoria Xia Tuesday, September 30, 2014 9:29 AM
Monday, September 22, 2014 4:00 PM