Hello all, I have a SharePoint List that stores project data, my goal is to have the workflow loop through the list, get the Max project number by department, add 1 and store this value as next available number or possibly create it as a new item in a list of next available numbers. Each department project number series is unique and mostly do not start at 1. The format is 9999-999. left 4 are the department code, and right 3 are the project number we have 305 departments. I have accomplished this using InfoPath and SharePoint Designer basically by grouping by department, converting the right 3 of PJ number to a number, then Max of Pj nuber + 1. I have been tasked to create this same query process in Nintex. So far I have a collection variable (collProjectNumbers), variable (NewProjectNumber and a list query. What I need help with, when the user submits the new form with the appropriate Department and code the workflow will filter on that department only and get the next number. I am new to Nintex and not sure how to tackle this one with the most effective approach.
thank for any help.
Thank you for the response, I have this working nicely so far, User submits a request for a new number providing department information from a look up in the form which is a data connection to a list with all departments with department codes. When a new item is created (form submitted) in the request form library the workflow fires and creates a new item in the project inventory list. Then a workflow fires on new item with the above actions. The first variable is the department code which is used to filter the query, all the projects for that department are stored in a collection variable and sorted Z-A using a number column [PJnumberRight3] then I perform the math to add 1, then I build the sting {Department code} - {NewNumber} then update the blank project number on the current item and the [PJnumberRight3] and update the form library request form with the new number like 9999-999. still working on the approval steps. So it seems my choice was to build another list or handle getting the max number using the list query. I will post my final solution once I am satisfied. thanks again I tried to stay with the InfoPath form because I have considerable time invested in the approval process.
