SharePoint components - business processes without development, InfoPath, SharePoint Designer or workflows. SharePoint Services, SharePoint Foundation & SharePoint Server 2010-2016.

Training

Event Calendar
Connected Fields

Create Item IDs using a seed value

When auto assigning an ID number it can be useful to begin from a seed value. Starting at 10000 ensures a uniform width for the record ID since the number of characters will always remain the same.

Instructions

  • Create a standard SharePoint text field to store the ID value Proj ID.
  • Use the Item ID settings to apply the pattern: Proj.[#|10000]
  • Apply settings as shown:

  • By checking the Edit option, any records that were previously created will also be updated with the next available ID.

 

Summary

The Item ID settings allow for the creation of dynamic patterns which can allow for the creation of a variety of IDs. Our example allows us to start from a seed value.

Last modified: 8/10/2015 6:27 PM
3 comments [latest: 5/11/2017 3:00 PM]
Danny [5/11/2017 2:27 AM]
Is there a condition to reset that ID number to start at 1 for example let say every 1st day of the fiscal year?
Vladi Gubler [5/11/2017 3:00 PM]
Danny: if you include the year as part of your pattern, it will do it automatically. It will always start with 1 if the rest of the pattern produces a unique new value.
 
Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.