SharePoint Document Library Formula Sequential Numbering unique to each prefix

Like (0) Share

Report

Posted on 24 Nov 2022 12:43:07 by LuisPertence

Hello Everybody!

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:

Are/DocType/Numb.

_____________________

FIN-FOR-001

FIN-FOR-002

FIN-PRO-001

HS-FOR-001

HS-FOR-002

HS-PRO-001

HS-PRO-002

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 have the same question (0)

All responses (2)

Answers (0)

Andrew_J 1,962 Moderator on 24 Nov 2022 at 13:04:19

Like (0)

Report

Re: SharePoint Document Library Formula Sequential Numbering unique to each prefix

@LuisPertence

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.

Regards,

Andrew

Was this reply helpful? Yes No
grantjenkins 11,059 Moderator on 25 Nov 2022 at 03:21:21

Like (0)

Report

Re: SharePoint Document Library Formula Sequential Numbering unique to each prefix

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.

Was this reply helpful? Yes No