locked
auto-incremented list columns RRS feed

  • 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


    Cheers,

    • 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


    Cheers,

    • 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