Generate Auto number Field in SharePoint list

By -

Generate Auto number Field in SharePoint list

To create auto generated list field do the following
1.       Create a column field with data type number in the targeted list. For example I am creating an auto generated column Case ID.

 

2.       Now to make the auto generated column hidden when a new item is created in the list we have to hide it in content types.
First go to list settings-> Then in General settings go to Advanced Settings
3.       In Advanced settings Click the radio button Yes , in Allow management of content types .And Click OK.
4.       Now go to list settings again and a new Content types will be shown. In that click the Content type. In my case it is Item. Name may vary for you.



5.       In that Content type all list columns will be shown. In that click the Case ID Column.

6.       After  that click the Hidden and then click OK

7.       Then open SharePoint Designer create a new workflow for the list when a new item is created

8.       And add update action to the list.

9.       Click Add .In set this field value select Case ID
10.   And for To this value select ID. Click OK and publish the workflow. Now a auto generated list column is created.



Comments

  1. UnknownFebruary 17, 2015 at 8:55 PM

    It is generating same number..not auto generated number

    ReplyDelete
  2. UnknownFebruary 24, 2021 at 12:48 AM

    Can you please expand on this item. I have a list that I would like to generate numbers automatically up to 25. But when one of the items is no longer needed, and it is deleted or archived, the number can be used again.
    I know it's been a while from your post, but thank you. I'd appreciate the assist. We are running this on SharePoint 2013.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to copy SharePoint list workflow

By -
Image
We often face a situation where we need to copy a big workflow from list or library to another list or library. This situation can be avoided if we have created the workflow as reusable workflow. So in this article I will explain in simple steps on how to copy a list workflow to another workflow using SharePoint designer. Using this method we can copy workflow across site collections are web applications. For this we have the following List Name Workflow Name List 1 List Workflow 1 List 2 List Workflow 2 (Copied from the worlflow1) Step 1) We have the list 1 with list workflow 1 to be copied to list workflow 2. Step 2) Now create a list workflow 2 , in list 2 with one condition plus once activity and save it. In our example I have used a condition and sending email to current user. This is used to create the Xoml rules for the list workflow 2 Step 3) Now in the side of navigation click All Files St...
Read more

INFOPATH FORM HIDE/DISABLE FIELDS BASED ON SHAREPOINT GROUP MEMBERSHIP

By -
Image
Hi guys in this tutorial you will get to know how to identify whether a user is part of a Share point group in InfoPath form. NOTE: This will work only for WINDOWS AUTHENTICATED SP sites In this example we will use the logged in persons user name is in IT SP group. If he is in the IT SP group we will enable Submit Button and If he is not in the IT SP group we will enable Submit to IT button. STEP 1: Go to the SP site. Go to People and groups and create a group IT. And Add users to the group. Added test user 1 in the SP group. STEP 2: Open the InfoPath 2010. Created 3 fields Name, Emp ID, Department and 2 Buttons Submit to IT and Submit STEP 3: Go to the Data tab and select Data Connections Add a Data Connection   STEP 4: A data connection wizard box opens. Select create a new connection and Select Receive data A...
Read more

KnowledgeLake To Exhibit At SPTechCon In San Francisco on December 5-8 2016

By -
St. Louis, MI /PRNewswire/ -  KnowledgeLake, Inc.  will be at SharePoint Technology Conference (also known as SPTechCon) in San Francisco, California December 5-8 to demonstrate a powerful platform that enhances the power of SharePoint 2013, 2016 and Online. The event will offer more than 80 classes and panel sessions presented by SharePoint experts. KnowledgeLake will be in booth #300. "This is a valuable event for administrators, developers, architects and business people who must deploy, maintain and maximize business value from SharePoint," said KnowledgeLake CEO, Bernie Schweiss. "We are excited to show how our solutions can enable organizations to enhance their SharePoint document imaging and management experience." On Monday, December 5, from 3:30-4 p.m., KnowledgeLake's Senior Director, Dr. Andrew Hutson, will conduct the class, "Top 5 Considerations When Moving Content to SharePoint Online." During t...
Read more