I am trying to create a column that will auto-populate a document number sequentially based on the prefixes when an item is created. I want the final numbering to look like this:
I have one column called Department (i.e FIN, HS) and one column called Document Type (i.e FOR and PRO) and I am able to concatenate those two columns and use the ID as the number but this won't give me a sequential number based for each unique prefix arrangement. It will only give me the ID.
Thank you and have a great day.
I think I understand this and have undertaken something similar myself this week.
The ID column will do all the leg work on sequential side, i.e. 1, 2, 3 etc.
Maybe the above will help. I would concatenate at the fee number in my example.
Then use us the below to create the library.
I hope the above helps you out.
Just confirming - is this for a List or Library?
If it's for a List, then can give you a fairly nice solution as you MUST enter all required fields before you can save the item.
If it's for a Library, then it gets more complicated as you can upload a file and the metadata (including required fields) won't be added initially. So, if you're trigger is When a file is created, it likely won't have the Department or Document Type values to build the unique id.