What is the best way to take information from a secondary data source and use it to populate one field within a repeating table? Must I resort to code? If so, does someone have a sample I could use?
Here is what I am doing:
I have in my form a repeating table with 4 columns. The first column is supposed to be a read-only text box which serves as a label. The remaining columns are data entry. Because this list is a little long and users will be populating most of the items, using a drop down list box and forcing them to enter item by item makes it very cumbersome for the users.
I would like to prepopulate the table using a secondary data source (web service in this case) that will fill in the labels. Then, when the user has completed filling in the grid, the submit will then push that to a web service which will then write that to a back-end table.
At the end of the day, I have to leave this infopath form with "power users" and not "developers" and I would like to avoid coding, but if I have to, then so be it. And if I must, does anyone have any sample code I can use?