Wednesday, November 5, 2014

Create Autonumber Unique Column in SharePoint List

Auto-numbering is quite a common requirement when working with SharePoint lists. Say, You may want to autonumber list items in SharePoint 2010 issue tracking list!

Here are some methods to achieve SharePoint list auto increment number:

Add Autonumber column to list with ID field:
SharePoint Lists have an built-in "ID" column which auto increments. You can simply Add this column to your views!
You can rename ID column if required: How to rename ID field in SharePoint list

Using calculated field for Autonumber?
Tried using calculated column with ID field, Entered formula such as = CONCATENATE("CR-" [ID]), But no luck - Doesn't work for new items! Because ID field is filled ONLY after the item is created!

SharePoint Autonumber with Workflows:
Here is my solution to set auto increment number with SharePoint designer workflow! Just follow these steps:
  • Create a column, say: Request Number of appropriate type. Make this column hidden: How to make a SharePoint list column hidden?
  • Open SharePoint designer, Create new list workflow.
  • Add a workflow action: "Update list Item" >> Current Item >> Add >> Set this field to your Target field (Change Request No.), Set value from Current Item:ID field. sharepoint add autonumber to list
  • Set the workflow start option to "Start Workflow automatically when an item is created"
  • Save and Publish the workflow.
You can also have an Event receiver to set Autonumber field value programmatically!

Create autonumber in SharePoint 2013 with "Counter" list approach:
Idea is, create an another list, say "Counter" with a field to hold your initial counter value. Create a workflow to fetch the counter value and update your bases list's "Auto-number" field. Let the same workflow increment the counter list's counter field value!

Tags: sharepoint unique autonumber, sharepoint 2010 add autonumber column, sharepoint calculated value autonumber, sharepoint autonumber column, sharepoint create autonumber, sharepoint 2010 autonumber column, sharepoint 2013 autonumber column, sharepoint autonumber workflow, sharepoint autonumber column in list, sharepoint autonumber field, sharepoint designer autonumber, sharepoint list autonumber formula, sharepoint calculated field autonumber, sharepoint autonumber generation, sharepoint autonumber list items, autonumber on sharepoint list, sharepoint designer 2013 autonumber workflow

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.

Check out these SharePoint products:

No comments :

Post a Comment

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...