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?
Page 1 / 1
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
The attachment below is how I made my workflow. Where would you place the build string operation?
Right after update SAR item list action and Before you update the form field action.
@Nunezma …can't you use ID column? It's going to always unique and incremental.
Reply
View our Community Site Map
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.