Auto number column in SharePoint list

mosssharepoint

In a SharePoint list I want an auto number column that as I add to the list gets incremented. How best can I go about this?

Best Answer

Sharepoint Lists automatically have an column with "ID" which auto increments. You simply need to select this column from the "modify view" screen to view it.

Related Solutions

R – Customize the Sharepoint add list column page

From what I understand you want to add a choice column data type thats already prepopulated so that users can then add it to their own content types?

have a look here, this is probably what you want to do: http://www.sharethispoint.com/archive/2006/08/07/23.aspx

Auto Number Column in SharePoint List with Link to Item

The answer is No... but you can create one.

Cracking open a website using SharePoint Manager (which rocks) you can see the definition of the "IssueID" column and the one that is used to display the "ID(link to item)" I include the schema xml from my site below

<?xml version="1.0" encoding="utf-16"?>
<Field ID="{de57307b-e69a-4cf9-b3a9-b6a728ecf773}" Sealed="TRUE" ReadOnly="TRUE" Name="IssueID" Type="Computed" DisplayName="Issue ID" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="IssueID" FromBaseType="TRUE">
  <FieldRefs>
    <FieldRef Name="ID" />
  </FieldRefs>
  <DisplayPattern>
    <Column Name="ID" />
  </DisplayPattern>
</Field>

<?xml version="1.0" encoding="utf-16"?>
<Field ID="{03f89857-27c9-4b58-aaab-620647deda9b}" ReadOnly="TRUE" Type="Computed" Name="LinkIssueIDNoMenu" DisplayName="Issue ID" Dir="" DisplayNameSrcField="IssueID" AuthoringInfo="(linked to item)" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="LinkIssueIDNoMenu">
  <FieldRefs>
    <FieldRef Name="ID" />
  </FieldRefs>
  <DisplayPattern>
    <HTML><![CDATA[<a  href="]]></HTML>
    <URL />
    <HTML><![CDATA[" ONCLICK="GoToLink(this);return false;" target="_self">]]></HTML>
    <Column HTMLEncode="TRUE" Name="ID" />
    <HTML><![CDATA[</a>]]></HTML>
  </DisplayPattern>
</Field>

Change the GUIDs and you can add these columns to a custom list, they will display in the manner you require. I would recommend creating a feature for the columns (maybe use STSDev) and releasing via a solution to any thing other than a dev site.

Best Answer

Related Solutions

R – Customize the Sharepoint add list column page

Auto Number Column in SharePoint List with Link to Item

Related Topic