SharePoint Integration

Re: displaying fields from Sharepoint list in drop down list boxes in repeating table

Laura — Mon, 12 Oct 2009 15:57:29 GMT

I am having the same problem only with repeating section and checkboxes although my form is not web based. I have a data source I have imported from SQL table and then I created fields for my checkboxes. When I generate form each repeating section/checkbox has all answers displayed, i.e. Question 1 is answered "Yes" one time and then "No" another time (as designed); On report both instances of Question 1 has "Yes" and "No" checked. Please let me know if this explanation is not clear.

Re: displaying fields from Sharepoint list in drop down list boxes in repeating table

stephanie — Mon, 31 Dec 2007 18:34:25 GMT

Thanks Clay! That worked. I appreciate the help!

Stephanie

Re: displaying fields from Sharepoint list in drop down list boxes in repeating table

Clay Fox — Fri, 28 Dec 2007 16:40:27 GMT

You would need a repeating group in your main data source with multiple fields. This will be the repeating table. Then you put drop downs controls on the repeating fields in your table and use your data connection values as the drop down display options.

You cannot use the fields from the data connection directly since you cannot store new ones and they do not repeat.

displaying fields from Sharepoint list in drop down list boxes in repeating table

stephanie — Thu, 27 Dec 2007 18:31:23 GMT

I am new to Infopath and having trouble getting information to display correctly in an Infopath form. I have a sharepoint list with three fields, Client, Project, and Task. I want to display these fields in an Infopath form repeating table.

When I create my secondary data connnection and setup drop down lists on the form, they display correctly. I want to be able to have these fields display in a repeating table, so the user can fill out a row with their Client, Project and task selected for each day of the week in a different row. When I try and place the three drop down lists in the repeating table it give me an informational message saying the "control cannot repeat here". When I publish the Infopath form, and it has multiple rows in the repeating table, the fields in each row display the same information, its like they are linked or tied together. I am unable to select for example, Client 1 in row 1, and Client 2 in row 2 of the repeating table.

Please help!

Thanks, Stephanie