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/118728.aspxMon, 09 Apr 2018 19:33:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118728Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118728.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118728Perfect, sounds like you have it doing what you need. :)https://www.infopathdev.com:443/forums/thread/118726.aspxMon, 09 Apr 2018 16:11:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118726spassler0https://www.infopathdev.com:443/forums/thread/118726.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118726Thanks Hilary, I was able to just copy the first rule i had which got the max and added +1 paste it and add the extra filter sayign if ot matches pattern \d\d\d then concat(0",my originalfomular+1) and it seems to work since the rules run in order i just put it under the top one and before submit and it works! :Dhttps://www.infopathdev.com:443/forums/thread/118719.aspxMon, 09 Apr 2018 14:49:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118719Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118719.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118719Numbers can't have a preceding zero, which is why you are having this problem. The field must be a string and then you'll need to use a formula to zero pad as needed (since once you hit 1000 you no longer need the preceding zero). Here's a thread on that: http://www.infopathdev.com/forums/p/20643/71474.aspxhttps://www.infopathdev.com:443/forums/thread/118712.aspxFri, 06 Apr 2018 22:35:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118712spassler0https://www.infopathdev.com:443/forums/thread/118712.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=118712so i have a field in an infopath form called autonumber i manually edit this field and set default value to 0300. then i edit the form to a use a formula which looks at my library and pulls the highest number +1 when i submit a new form. well i do it but when i submit it i just get 301 instead of 0301. Is there any way to carry that first 0 over and have it show up? I have tried making the autonumber field a decimal and a whole number for the properties neither of which i have had luck with, any info would be great!