kwizcom banner advertisement

Create Autonumber Unique Column in SharePoint List

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

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

Add Auto number 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!
sharepoint add autonumber to list
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 calculated value autonumber, sharepoint create autonumber, sharepoint autonumber workflow, sharepoint autonumber column in list, sharepoint designer autonumber, sharepoint list autonumber formula, sharepoint calculated field autonumber, sharepoint autonumber list items, autonumber on sharepoint list, sharepoint designer 2013 autonumber workflow
Create Autonumber Unique Column in SharePoint List Create Autonumber Unique Column in SharePoint List Reviewed by Salaudeen Rajack on 1:17 PM Rating: 5

No comments:

Please Login and comment to get your questions answered!

Powered by Blogger.