Custom ID: CM123 - DATE (MMDDYY)

4 years ago
15 October 2019
6 replies
18 views

mcamarco
15 replies

I'm trying to generate a custom ID for our Change Management list. I need the number to start from 325 as our old list stops there and automatically create the next. The format will need to be as follows:

CM326-MMDDYY

CM327-MMDDYY

Each new form filled out will need to create a new custom ID to be populated in the "title" column. How can I create this to show in the form/list?

6 replies

+12

@mcamarco ....is your list brand new? If the first item you create in this list has ID = 1 then you can use calculated action in workflow to add 324+{ItemProperty:ID} which will give you 325 and onwards.

Then using build string you can create the custom ID

Userlevel 6

+22

SimonMuntz
Community Manager
2190 replies
4 years ago
15 October 2019

To show in the form:
This Knowledge base article shows you how you can read the previous value in the list and once you have that you can increment it.

Other wise you could have a workflow run after the form is submitted to update the Title by reading the previous vbalue and incrementing it.
This method is better than relying on the item ID because if an item is deleted it could mess up your count.

I do need to be able to show this within the form, as well as populate it on the SharePoint list. If one is deleted, it is okay to continue counting.

EX:

CM325-MMDDYY

CM326-MMDDYY (deleted)

CM327-MMDDYY

What is the article you are referencing @SimonMuntz ?

The list is not brand new, but I know what number the ID is up to. What function would I use in the workflow & how would I push it to populate into the form? Set feild in current item with the variable/string?