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?
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