InfoPath Dev

 Hello,

 I've only been working with InfoPath and MOSS for a couple weeks now and have run into a problem I haven't been able to solve. I am creating a dashboard form - basically a form that will show an overview of all projects that have been created using another form and submitted to a SharePoint library. The problem is, when the user submits the first form I have repeating tables in order to facilitate a one to many relationship, and I submit this data using the merge column function. When I try to extract that data from the library into my dashboard form, InfoPath parses it into a single string with each value separated by a space.

 Is there anyone to separate these values so each one will have its own separate row? I've done a lot of reading and seen things about the eval function and a lot of other stuff, but nothing concrete. Let me know if this isn't enough information.

Thanks for any help!

-Danny

Hi,

This is a limitation of InfoPath and SharePoint.  There is no way without custom code to fix this.

What you might want to look at is our qRules product that has a command to do this called "Submit to SharePoint List". (See product description)  If you use this tool you can get each row in your repeating table in InfoPath to submit to it's own row in a SharePoint list. Then you can create your dashboard.  You can do this with your own custom code but qRules is way faster and easier (and you don't need to know code).

Here is nice demo video we have showing you how to use the tool to accomplish what you want: http://www.screencast.com/users/qdabra/folders/Default/media/aa7cd492-0b27-4516-9f15-a73f83c7c095

Ted