Dear Infopath Gurus,
I am facing a problem while fetching data from a (web-based) Infopath form library, as a secondary data source.
Background: I have connected text-boxes on the form with a form library (secondary source), these text boxes are suppose to fetch values from the associated columns (dynamic in nature) and display it on the web form. But whenever I
reopen the form, these text boxes do not fetch or display the updated values in the columns.
The temporary solution that I applied was, applying a rule (Query using a data connection) whenever a form opens/loads. This solution was bringing the updated values alright but as the number of forms in the form library increased, a form was taking more
than a minute to load. Which is totally unacceptable at user end.
I also tried to apply a similar rule (Query using a data connection) to the text boxes on the form but for some unknown reason its not fetching the updated values from the form library. I am carefully putting an easy condition to trigger
the last mentioned rule but its not giving the required result.
Despite associated/connected with the secondary source columns, the form is not fetching the updated values on its own
If I associate a (data query) rule whenever the form opens or loads, it takes ages to load
If I associate a (data query) rule with the text boxes instead it
View Complete Post