Training Record Form - InfoPath Dev
in

InfoPath Dev

Training Record Form

Last post 05-15-2013 07:07 AM by terrib49. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 05-13-2013 02:42 PM

    Training Record Form

    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.

  • 05-14-2013 05:14 AM In reply to

    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.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 05-15-2013 07:07 AM In reply to

    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?
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.