InfoPath Dev

Posting an update if it will help somebody else with the same problem. Since my customer is only interested in getting an Excel output I decided to write some code in Excel VBA. I'm not going to post any code, just conceptualize the manual process. 1. Customer exports to Excel and downloads the .iqy file 2. Opens the .iqy file in ...

Here is a sample - save the file locally, right click, select design, preview. There are 20 rows by default in the repeating table - so you can see the two formatted tables showing only the first 5 and the last 5

Based on the row account

Yeah, you can do that with formatting rules. Do you want to hide based on a value? Or based on a row count?

I am having a hard time understanding the issue - any chance you can attach a copy of your form to a reply (under the options tab) and give me a hint about where to look for the issue? I'm happy to take a look. :)

I have a field in infopath form which has a recalculated formula and have filter condition on the recalculated formula to show the results. But I have old forms submitted it is not working for them. it does not showing the exact data stored in this field on main view. How I can show the data stored on the view on form load? is there any idea?

Hey Hilary is it possible to limit the shown itmes in a repeating table. F.e. I have a repeating table in which a user can insert as many items as he wants. Beside that I have another table which has at the moment the same amount of items as the other table, which is logical. So what I actually want is to limit the amount of items of one ...

Works great!!! Thank you!!!

Same for me. I moved your formula - off the field and onto the repeating group (see attached, save locally, right click, select design - rule is now on the repeating group) and republished, and now I think it works as anticipated?

Thx Hilary, A stripped down form is attached. The only field that does not have preceding-sibling is the Start Date It works fine in the filler but not after it's published to SP Online version 16.