cancel
Showing results for 
Search instead for 
Did you mean: 
ncocchiara_77
Nintex Newbie

Adding a letter prefix and year suffix to a field numbering sequence

I created a form and workflow for a SharePoint list.  I set up a calculation to populate a field with the next number using a next number list, variables, and math function in the workflow to calculate the next number for a new form entry.  The problem is, the user wants a location prefix (I have a field for location on the form) before the number, along with the current year after the number, so that the format for the next number will be: NYC_100_2020.  Can anyone help me with this?

Labels: (2)
Tags (1)
0 Kudos
Reply
4 Replies
claudiaurbanski
Nintex Newbie

Re: Adding a letter prefix and year suffix to a field numbering sequence

Not sure how your workflow looks, however in my case I added a build string action to add my text + nextnumber save it in a variable and then update my field with that variable containing CAR_001, CAR_002 etc

 

claudiaurbanski_0-1607617200650.png

 

0 Kudos
Reply
ncocchiara_77
Nintex Newbie

Re: Adding a letter prefix and year suffix to a field numbering sequence

The attachment below is how I made my workflow.  Where would you place the build string operation?

 

 

0 Kudos
Reply
claudiaurbanski
Nintex Newbie

Re: Adding a letter prefix and year suffix to a field numbering sequence

Right after update SAR item list action and Before you update the form field action.
0 Kudos
Reply
kunalpatel
Automation Master
Automation Master

Re: Adding a letter prefix and year suffix to a field numbering sequence

@claudiaurbanski …can't you use ID column? It's going to always unique and incremental.

Reply