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/117872.aspxFri, 15 Dec 2017 15:58:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:117872Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/117872.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=117872<p>I think you&#39;ll have to add a condition to your rules to check and see if you have a budget for the year. That may be a condition that checks the returned rows for the current budget year (using a contains condition) - if there are none, you could set the field to -001. So - two rules, one that runs if you find the year and one that runs if you do not. :)</p>https://www.infopathdev.com:443/forums/thread/117864.aspxThu, 14 Dec 2017 10:29:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:117864Hélianza0https://www.infopathdev.com:443/forums/thread/117864.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=117864Hello, I have a trouble with an auto-increment. We have BUdget, writen like this BU[YEAR]-[001]. When a user create a new budget, I need to take the max budget in the concerned year, and increment it. So I have a formula who look all the budget with this year, take the max ID, substring to have the three last digits, add one and it&#39;s ok ! My problem is : when i don&#39;t have any budget in the year, I have no return. And I can&#39;t make my +1. So, my question : how to increment a name like BU2018-002 to BU2018-003, with only one rule in infopath, and create BU2019-001 if there is no 2019. Sorry for my language, and thanks ! Hlz