So this is a bit of a strange one and I cannot seem to figure it out; I should preface that I'm fairly new to InfoPath.
I have a form with a repeating table that is pulling data from a secondary source. In order to grab the appropriate data I have added a field called "counter" with the default value of: count(../preceding-sibling::my:ProductInformation) + 1.
I want to have the values be static for the user. So I added 9 rows of the repeating table by default. I then use a rule to hide any values where counter is greater than the number of items in the secondary data source repeating table; which I have passed to the main data source in a field called "PTRowCount." I then default "PTRowCount" to 0 and have a rule that changes this value to that of the secondary data source table when the data is queried. This allows for all the rows to be hidden until a query occurs, and then only shows the rows with data in them.
This works fine in the InfoPath form filler, but throws the infinite loop error when I try to open the form in the browser.
I've noticed the following:
- At six rows, the form will load without error.
- More than six rows will trigger the infinite loop error
- At nine rows the first row of the table will always show prior to querying the secondary data source and be blank
- At nine rows: If "PTRowCount" is defaulted to 10 then all rows will show, but the count for last row will be blank. (I bound a field in the repeating table to "counter.")
- If I remove the default value for counter, I no longer receive the error and everything works fine.
That's it. I cannot figure it out. I have another form that's using the exact same syntax and pulls data in the same way from the same secondary data source and it always works in the browser. I have tried comparing the rules and actions for each form and they seem to match exactly. I cannot figure out why this form is behaving this way. Any help is greatly appreciated.
I have attached a copy of my form for reference.
Thanks,
Dan