Welcome to Office and SharePoint Pro Sign in | Join | Help
in Search

SUBSCRIBE to Windows IT Pro Magazine & SAVE 30%      FREE Email Newsletters Vista UPDATE, Windows IT Pro UPDATE & More

Office and SharePoint Pro » SharePoint (WSSv3 and MOSS2007... » Development and Programming » Automatic list numbering?

Automatic list numbering?

Last post 08-05-2008, 4:59 PM by misterbeefy. 6 replies.
Sort Posts: Previous Next

  •  09-14-2006, 5:02 AM 26209

    Automatic list numbering?

    Reply Quote

    Hello colleagues,

    is there any possibility in WSS to have a column which automatically assigns a number to each newly created item? Something like ID, but "more visible and usable"...or, if possible, not only 1,2,3, but something like "year-XX" etc.

    Thank you a lot!

    Marek Hlavac

  •  09-20-2006, 9:36 AM 25654 in reply to 26209

    Automatic list numbering?

    Reply Quote
    If you create a list from the Issue template, you will have an ID number that is an auto-number. Bur you can also had a calculated column to an existing List, and set a formula with the ID field (hidden) and a text or another field (i.e. Title).

  •  09-20-2006, 10:11 AM 26210 in reply to 26209

    Automatic list numbering?

    Reply Quote

    >If you create a list from the Issue template, you will have
    >an ID number that is an auto-number. Bur you can also had a
    >calculated column to an existing List, and set a formula
    >with the ID field (hidden) and a text or another field (i.e.
    >Title).

     

    Hello Ricardo,

    thanks a lot!!! Did not know that I can use a hidden column in the formula. It works. Wonderful!

    Marek Hlavac

  •  09-21-2006, 1:19 AM 26212 in reply to 26209

    Automatic list numbering?

    Reply Quote

    >If you create a list from the Issue template, you will have
    >an ID number that is an auto-number. Bur you can also had a
    >calculated column to an existing List, and set a formula
    >with the ID field (hidden) and a text or another field (i.e.
    >Title).

    Hello Ricardo,

    I was a bit disappointed today...I tried to create this auto-number field with Concatenate([ID];"-";Year([Created])).

    The formula works, but there is one problem: if I create a NEW item, the formula's results are faster than the ID assignment, so the result of =ID is always ZERO. If I add a column to an existing list, the result is OK as expected - unless I add a new item.

    How to get around this?

    Thank you

    Marek Hlavac.

  •  09-21-2006, 2:24 AM 25655 in reply to 26209

    Automatic list numbering?

    Reply Quote
    Does this also happens with the Issue lists?

  •  09-21-2006, 2:43 AM 26211 in reply to 26209

    Automatic list numbering?

    Reply Quote
    Yes. I haven't recognized any differences between Issues and other list types in this case.

  •  08-05-2008, 4:59 PM 29929 in reply to 26211

    Re: Automatic list numbering?

    Reply Quote
    Funny you should ask. I just recently did this exact thing for a client. I created an itemadded event handler that added 1000 to the ID field and placed in in a new column called project ID. I also applied the same calculation to the itemupdated event, in order to keep it from being changed by any user.
View as RSS news feed in XML
SPONSORED LINKS FEATURED LINKS

Extend SharePoint to the ExtranetView this web seminar to learn how SharePoint administrators can improve partnering and collaboration effectiveness. Order Your Fundamentals CD Today!Get up to speed quickly and learn how to uncover rich information management capabilities with this free SharePoint CD. Keep Project Teams on TrackProtect you project team productivity by keeping SharePoint running. Download this white paper to learn about Continuous Data Protection for SharePoint. Leverage Hosted Exchange and SharePoint See how a business of any size can strategically acquire the messaging and collaboration infrastructure of a Fortune 50 enterprise. Top Factors in a Successful Disaster Recovery PlanAre you gambling with disaster? Chances are, you won't ever experience a Level Four disaster, but even the smaller-scale disasters can paralyze business operations unless you've developed a plan for rapidly restoring IT services. The Essential Guide to Fax Server SoftwareThis fundamentals eBook will introduce you to the IT benefits of fax servers. Learn how you can better serve your company’s customers while still implementing a solution that is easy to support, secure, and integrate. Maximize your SharePoint InvestmentLive, in-person training on how to architect and administer the optimal SharePoint infrastructure. Take advantage of Early Bird pricing - $99! Find a new job on the all new IT Job Hound!Search jobs, post your resume, and set up job e-mail alerts! Get Specialized SharePoint Training!SharePoint MVPs Dan Holme, Michael Noel, and Andrew Connell share their perspective and expertise in these exclusive eLearning seminars. One Event for developers and one for IT pros. Choose the one that fits your needs! Top 5 SharePoint Migration StrategiesAchieve stress-free content and user migration to an online collaboration platform! View this on-demand seminar to learn how. Access Expert SharePoint Solutions for only $5.95!With the online Monthly Pass, you can have all the SharePoint solutions in Windows IT Pro right at your fingertips, including access to the more than 10,000 articles in our content archives! You'll also receive a full digital copy of the latest issue of W Leverage Your SharePoint InvestmentAre you losing productivity or profit due to poor document management processes? View this seminar to learn how MOSS can help.