How can I  create an Autonumbering field in a Microsoft SharePoint 2007 List

Posted on 2012-08-15
Last Modified: 2012-08-20
How can I create an autonumbering field in SharePoint 2007?  In eRoom it was an already defined field.  I can't see a similar feature in SharePoint.  I want to be able to create a unique number for each row created within a list.

Thanks for your help!
Question by:DnGreenwood
    LVL 9

    Assisted Solution


    Author Comment

    Unforutnately I do not have permissions to go into SharePoint Designer.  Is there another way?
    LVL 44

    Accepted Solution

    by default each element in a list will get its unique number in the ID field.
    The only difference to e.g. an identity column like in SQL Server is, that if you delete the last item, the next one will get this number again.

    What is the purpose of your autonumber?

    Thanks and HTH

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now