https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/121395.aspxMon, 19 Aug 2019 15:48:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121395Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121395.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121395It is one of those things that seems so very simple but can really be a pain. You basically need to "reserve" a number for each potential form in able to be completely confident that you won't have duplicates. There was a post here just a few weeks ago where a form designer had an accidental overwrite in a library because of two forms having the same number. So, I guess I'd question the necessity of this numbering. I like using the user name function and the now function for a unique file name. Just promote the Job Number field if you need that. Make sure you keep the file name stable (i.e., have a filename field, only set it if it is blank, use that field in your submit data connection).https://www.infopathdev.com:443/forums/thread/121394.aspxMon, 19 Aug 2019 15:40:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121394timlyons7450https://www.infopathdev.com:443/forums/thread/121394.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121394Thank you for the reply! I will work on setting that 2nd rule but Is there an approach you would recommend that will get me similar results but with a cleaner outcome?https://www.infopathdev.com:443/forums/thread/121392.aspxMon, 19 Aug 2019 15:36:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121392Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121392.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121392So - you just need a second rule to handle for this. If the data connection you are using to get back the numbers has no rows, use "1", otherwise use the max number plus one. In general, I don't recommend this approach - there is always a chance more than one user will get the name number.https://www.infopathdev.com:443/forums/thread/121381.aspxThu, 15 Aug 2019 15:45:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121381timlyons7450https://www.infopathdev.com:443/forums/thread/121381.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121381Hey all, Im new to the forums and also fairly new to infopath, I was hoping someone could help me out with this. I've been tasked with making an infopath form with an auto increment number in sharepoint from our infopath form. Basically my problem is: currently we can create an auto incrementing number but we cant get the first number to start at 1, It names the form "job name-NaN". If screenshots will help, I can submit those. Thank you for your time!