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
+11Not 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
+2The attachment below is how I made my workflow. Where would you place the build string operation?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.