SharePoint Integration

Re: Training Record Form

terrib49 — Wed, 15 May 2013 14:07:15 GMT

Thanks for the thoughts. I don't mind using a list but couldn't get it to feed the training course information to each row from the InfoPath form. The individuals reporting the information are not always great at data entry so my goal was to cut down on their typing! Can I get that to work or do I need two list and join together using a course code?

Re: Training Record Form

ErnestoM — Tue, 14 May 2013 12:14:43 GMT

This is not easy! Let's just make sure that's understood up front. :)

A SharePoint form library doesn't store flat data (e.g. a row in a repeating table). The form library stores XML forms, so what you're trying to achieve is submit an individual XML form per row, and do this iteratively for however many rows have been entered.

You may be able to:

1. Create a secondary data source with the XML schema you wish to submit to the form library.

2. In the form, iterate to set the values in this secondary data source, and submit each row into the form library.

This will most likely require writing custom code. We have a product called qRules which might be able to help, but this is a scenario that I've never seen implemented.

It might be worth taking a step back and asking why the iterative submit is needed. Will users be opening up each XML file to make changes (perhaps to other fields) and resubmit? If so, then I understand your scenario. You're basically bulk generating XML documents ahead of time for users' convenience.
Or is the data just needed in a flat structure? If so, then why not submit to a SharePoint list? A SharePoint list will store flat data and not XML documents.

Training Record Form

terrib49 — Mon, 13 May 2013 21:42:57 GMT

Is it possible to create a form in InfoPath that will record multiple records to a SharePoint library. For instance,

At the top of the form, I need to describe the training event, (Name of course, day, time, etc...)

For this one event, I may need to enter 50 names of attendees. When complete, I need 50 records created, reusing the training event information in each row next to the employee name and department. Is this possible? I've tried repeating tables, repeating sections and can't manage to come up with the right combination.

Any direction or help would be greatly appreciated.