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?
Adding a letter prefix and year suffix to a field numbering sequence
+2
+11
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
+2
The attachment below is how I made my workflow. Where would you place the build string operation?
+11
Right after update SAR item list action and Before you update the form field action.
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.