locked
Can I create another coulmn than ID for serial number in list. RRS feed

  • Question

  • I'm using Sharepoint 2007. I want to create a coulmn other than 'ID' which will give me runnning number, like serial number.
    Tuesday, October 30, 2012 3:46 AM

Answers

  • Hi Amit,

     Please try to follow the below link which may help you to create custom Identity column in SharePoint 2007 list.

    You will probably need an ItemAdding event handler to look at the your custom id before it gets added and then adjust it if needed. 

    I would start here:

    http://msdn2.microsoft.com/en-us/library/ms442323.aspx
     
    There is also a Channel 9 video (by Ted Pattison) on the process here:

    http://channel9.msdn.com/ShowPost.aspx?PostID=197655

    Regards,

     Sekar

    Tuesday, October 30, 2012 6:52 AM
  • Hi

    the easiest way

    attahc a workflow to your list

    when an item is added, in the workflow ionsert step which will update that new column with  current:ID +" what you need string"


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Wednesday, October 31, 2012 2:39 PM

All replies

  • Hi Amit,

     Please try to follow the below link which may help you to create custom Identity column in SharePoint 2007 list.

    You will probably need an ItemAdding event handler to look at the your custom id before it gets added and then adjust it if needed. 

    I would start here:

    http://msdn2.microsoft.com/en-us/library/ms442323.aspx
     
    There is also a Channel 9 video (by Ted Pattison) on the process here:

    http://channel9.msdn.com/ShowPost.aspx?PostID=197655

    Regards,

     Sekar

    Tuesday, October 30, 2012 6:52 AM
  • Is it working fine?

    Regards,

     Sekar

    Wednesday, October 31, 2012 5:30 AM
  • Hi

    the easiest way

    attahc a workflow to your list

    when an item is added, in the workflow ionsert step which will update that new column with  current:ID +" what you need string"


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Wednesday, October 31, 2012 2:39 PM
  • Hi,

     Did you resolve this issue? If you resolved this issue by following any of our replies, please mark it as answer. If you found or find some other solution to fix this issue, please post that solution here and mark it as answer. So that if others get the same issue, they will be in position to follow our forum threads. Please help others. 


    Sekar - Our life is short, so help others to grow

    Whenever you see a reply and if you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Alternate TextMark As Answer

    Friday, November 16, 2012 2:38 PM
  • Thanks Hemendra for marking as a answer

    Sekar - Our life is short, so help others to grow

    Whenever you see a reply and if you think is helpful, click "Alternate TextVote As Helpful"! And whenever you see a reply being an answer to the question of the thread, click "Alternate TextMark As Answer

    Monday, December 31, 2012 12:57 PM