https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/120680.aspxTue, 26 Mar 2019 18:22:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120680Fatihteke0https://www.infopathdev.com:443/forums/thread/120680.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120680Oh I didn't know that :) Thank you so so much Hilary. This form the best form i have ever seen for me :) You can't imagine how you helped to me. Best Regardshttps://www.infopathdev.com:443/forums/thread/120679.aspxTue, 26 Mar 2019 18:06:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120679Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120679.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120679You need to change the first dropdown to Select a field or group, then navigate to the repeating data source. See attached.https://www.infopathdev.com:443/forums/thread/120678.aspxTue, 26 Mar 2019 18:01:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120678Fatihteke0https://www.infopathdev.com:443/forums/thread/120678.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120678Hilary you are the Queen of the Infopath ! :)) this is awesome. I taken 2 pictures. in your form there is a rule "number of occurrences of sharepoint list item". How can you create it? Because i havent that option (picture two is mine)https://www.infopathdev.com:443/forums/thread/120673.aspxMon, 25 Mar 2019 23:32:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120673Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120673.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120673Here's a copy of your form w/ a second rule on the button to reset field17 if no data is returned from the query.https://www.infopathdev.com:443/forums/thread/120672.aspxMon, 25 Mar 2019 21:59:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120672Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120672.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120672In the screenshot you posted, see where it says "Field" in the middle input field - there is a field picker button to the right. If you click that, you'll see that the field I am setting is the one in the data connection you created - it is a query field for the data connection. Here's a blog post that may help you: https://wonderlaura.com/2011/08/01/infopath-query-specific-sharepoint-list-data/ I'll set up the other rules later today / tomorrow in the last form I posted and add it to a reply.https://www.infopathdev.com:443/forums/thread/120671.aspxMon, 25 Mar 2019 21:14:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120671Fatihteke0https://www.infopathdev.com:443/forums/thread/120671.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120671Hilary thank you so so much. I am really want to you set rules for no matches found. I will appreciate it. I check your rule and i see that ( in attachment) I couldn't understand why you set field to same field ? and why field18 name is Field_x0020_18 ? I cannot figure out.https://www.infopathdev.com:443/forums/thread/120662.aspxFri, 22 Mar 2019 19:28:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120662Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120662.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120662Now you see what I was trying to explain. :) So - go look at the rule on the button - I added one rule. It sets the query field in your data connection to the product type that you entered. Then, when the query runs, only the matches are returned. Now, you will need to handle for the case where no matches are returned. Want me to set up the rules for that for you? And you also should be doing this as part of your submit rules (because otherwise, if a few people have the form open at the same time, you could end up with multiple people with the same number) but this at least gets you headed in the right direction.https://www.infopathdev.com:443/forums/thread/120661.aspxFri, 22 Mar 2019 19:09:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120661Fatihteke0https://www.infopathdev.com:443/forums/thread/120661.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120661oooooooooooooooooooo My Gooooooooooooooooooooooooooooddddddddddddddddddddddddddddddddd !!!!!!!!!!!!!!!!!!!!!! You are unbelievable !!!!!!! How can you do that !!!!! Thank you so so much Thank youuuu :)))) I didn't understand but i will try to understand Thank you Thank you Thank you :))))))))))))https://www.infopathdev.com:443/forums/thread/120660.aspxFri, 22 Mar 2019 18:49:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120660Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120660.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120660Ok. Did you try entering one of those values (01, 02, etc) in the Product Type field and clicking the button? Do you have any forms submitted in your library?https://www.infopathdev.com:443/forums/thread/120659.aspxFri, 22 Mar 2019 18:33:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120659Fatihteke0https://www.infopathdev.com:443/forums/thread/120659.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120659Hello Hilary, I am sorry my mistake. Field 18 is Product Type. It can be 01,02,03... to 10. Each product Type has their own different Product number. That's why if Product Type is equal 01, than "Product Number" must be "max product number for 01" I mean i have 10 different Product Type and all of them have different Product number.https://www.infopathdev.com:443/forums/thread/120658.aspxFri, 22 Mar 2019 18:17:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120658Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120658.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120658In your latest form, field18 is the product number, so in that case in your "Get Product Number" rules, you'd set the query field18 in the Teklif No Form to the selected Product Number. I've added that rule to this form, just in case I've guessed correctly. Save the file locally, right click and preview. Enter an existing product number (something that is in your library already) and then click your Get Product Number button - that should return only the data from the library where the product number matches. Then it gets the max and adds 1. If there is no data that matches, you'll get NaN - and then you can set it to 1.https://www.infopathdev.com:443/forums/thread/120657.aspxFri, 22 Mar 2019 18:05:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120657Fatihteke0https://www.infopathdev.com:443/forums/thread/120657.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120657Hello Hilary You are the best :)) I create it like this. It works for me. Its ok :) Only I cannot understand product type section. Thats why i will create 10 different form for each product type :) Realy thank you for your help. Best regardshttps://www.infopathdev.com:443/forums/thread/120656.aspxFri, 22 Mar 2019 16:52:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120656Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120656.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120656Yes. The top section.https://www.infopathdev.com:443/forums/thread/120655.aspxFri, 22 Mar 2019 16:48:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120655Fatihteke0https://www.infopathdev.com:443/forums/thread/120655.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120655is this screen ?https://www.infopathdev.com:443/forums/thread/120652.aspxThu, 21 Mar 2019 21:53:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120652Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120652.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120652When you publish the form to SharePoint (not quick publish, but walk through the publish wizard) you can select columns to promote to your library.