Tutorial

Associated Items
List Search

Create Item IDs using a seed value

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

Instructions

To get started, it's advisable to create a new column in your list or library. Since the "ID" column is a default for all lists and libraries, you'll need to name it something slightly different. The column should be set up as plain text.

Click the Ultimate Forms Design link in the menu bar to open the Ultimate Forms home.

Click the Item IDs link in the Business Logic to start working with the ID feature. When the window opens, Click the + Add new profile link to start a new schema.

In the Column field, click the drop-down and select the column where you want to add the ID value.

Select the On New check box to create an ID for all new records. Typically, you will deselect the Edit Item option - this would change ID numbers whenever you edited records, which would mess things up badly! Likewise, you typically want to select the Prevent Manual Editing option - you don't want to give people the ability to change ID numbers under normal circumstances.

Click into the Pattern area to open the Pattern builder. For this example, we'll assume that we have projects to track, so we'll start the pattern with "Proj." We'll then add the standard numerator function so that each new record is one more thant the last.

To use a seed value - that is, to start the numbering at a specific point - click into the numerator brackets after the number symbol and add a "pipe" character (|), then enter the starting point for your numbering. In this case, we'll start at 10000.

Save the pattern, then save the ID schema.

When you retunr to your list and start adding records, you'll see the pattern works as anticipated.

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: 3/7/2020 12:11 AM
Loading...

Add your comment

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.
Infowise logo
© 2005-2021 Infowise Solutions Ltd
Microsoft partner logo
GSA Schedule
Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.