Modify the New form in a SharePoint list to use repeating tables and qRules - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Modify the New form in a SharePoint list to use repeating tables and qRules

Last post 08-03-2014 08:39 PM by JenniferLindsay. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-31-2014 11:14 AM

    Modify the New form in a SharePoint list to use repeating tables and qRules

    Hi all,

    I have a SharePoint 2013 custom list.  I'd like to use the Customize Form button on the list's Ribbon to modify the New form to add a repeating table that holds 6 of the fields in the list, then use qRules to submit that repeating table info back to the list.  This is a vehicle inspection list and I'm trying to avoid a user having to submit two separate forms to report two different inspection issues.  My struggle is that I can't find a way to make a repeating table for just those 6 fields without making the entire table repeating.  The ideas is that the first 16 rows would be the same information for each of the inspection issues, which would themselves be different, of course.

    I'm under a little bit of deadline pressure, so any help you can offer would be very much appreciated.  Can you work your magic for me once again?

    Thanks,
    Nancy

    -Nancy
  • 08-03-2014 08:39 PM In reply to

    Re: Modify the New form in a SharePoint list to use repeating tables and qRules

     Hi Nancy,

    If you already have qRules installed, then I'd suggest using a generic blank InfoPath 2013 form instead of a list form. Then you can make the first 16 fields non-repeating and the other 6 fields can all belong to a repeating section. If you then use the qRules SubmitToSharePointList command, you can submit all of the fields, repeating and non-repeating, to a list. 

    For example, if a vehicle has 3 inspection issues, then an inspector would open up a new form for the vehicle, enter the information for the first 16 fields, then enter 3 separate repeating rows (6 fields each).  When the inspector submits the form, your SubmitToSharePointList command would create 3 rows in your list, where the first 16 columns in the list would all have the same data, and the remaining 6 fields would all be different for each of the 3 rows.

     Let me know if that makes sense.

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

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.