InfoPath Dev

 Hi All,

I am having a really hard time trying to figure out how to split up data, from a secondary data source (SharePoint List), in a repeating table - in a browser enabled form.

Note: data is from a SharePoint list and I am simply displaying all the list items as checkboxes in InfoPath in a repeating table.

> What I want is a 3 column table with 10 results in each column, instead of what I'm getting, which is all the results being displayed in 1 column.

I found one article on msdn about how to filter data using the form code, but it wasn't suited to my needs, and I am brand new to InfoPath and can barely understand what's happening in the code, much less modify it to fit my requirements.

Thank you!

bump. Can anyone help me with this?

So is the SharePoint list data in a single column? And you just want it layed out in a specific manner? Or you want the SharePoint data to be used to populate fields in your main data source? I don't really understand what you are trying to accomplish...

Yes, I have the SharePoint list data coming into the table in only 1 column, and I need it split up into 3 columns...as in these pictures:

What I'm getting:

 What I want:

 Let me know if you need any more information!

If you are using IP 2007, you could use a repeating section and have it repeat horizontally -- put it in a layout table cell to restrict how far across the page it goes.... just use a repeating section rather than a repeating table, then under Display, select repeat horizonatlly.

 

Ok, but will  this work in a browser-enabled form?

I'm sorry, no, horizontal repeats aren't supported in browser forms (I really should pay more attention to the forum the post is in!).

Let's see. You almost need to put in three repeating tables side by side and then use conditional formatting on the table to only display a certain number of rows. I'll try to see if I can figure something out with that a little later today.

Okay, you can right click the link in the header to this post and use Save as to save the attached template sample. After you've saved, open in design mode and preview.

I used an xml data source, so that you'd be able to preview it. There is conditional formatting on each of the three tables, using position and count to pick which third of the secondary data source rows to display.You'll probably want to play with it some to get it displaying the way you like, but hopefully this will give you an idea of an approach you can take.

Thank you, that is exactly what I need, but it says "Use of unsupported XPath functions, position() and last()" when I checked compatibility with my server!

Man, it must be Monday, 'cause I just can't get this right. Again, browser compatibility!

This version doesn't use position(), it uses preceding-sibling, and the design checker is showing no errors for me....

Thanks, that works perfectly. One more thing though, when viewing the published form in the browser, upon clicking any of the checkboxes, they say "Yes"....Right next to the checkboxes, in the same repeating table, I have an XPath Expression box to display the title of the SPList item, simply @Title. Do you know why the text would change to "Yes"?

I just figured out why it's changing to "Yes" (because my checkbox's default value when checked is "Yes" and @Title reflects this) but I don't know how to get it to stop changing.

Ah, so you have check boxes bound to the @Title field from the ShP list. What do you want to have happen when the checkbox is selected (aside from *not* changing the title to 'yes')?

 Well I seemed to have solved the problem. I created a new lookup column in my SharePoint list which I linked to the Title column, unbound. Then I changed the xpath expression box which was serving as the title of the checkboxes on my form, to reference this new field. Now it doesn't change when they are clicked.

Now a new problem has come up...When I add a new item to my SharePoint list (Test Item 1), a duplicate checkbox is inserted on the form as you can see below.

However when I insert 2 items to the list, the duplicate goes away.





Any idea why this is happening?