Browser Forms

Re: CRUD operation with Infopath 2010 from with multiple list data in repeating tables

Patrick Halstead — Sun, 14 Jul 2013 22:01:58 GMT

Hi again,

You don't need code to populate the repeating table. You can use default values as well.

I'm attaching an example CopyRepeating.xsn that shows two techniques:

Default data - you add rows to your main data source and then use the side-effect of setting a column to trigger rules on the rows to copy from the secondary data source
qRules Insert - this is our common code library that inserts rows into your main data source and then has the same side-effect as in #1

We used to respond to individual write-code-please requests, but stopped doing it since there were so many. Now, we just tell people to use qRules. qRules free trial exists and the price is low. All proceeds go to supporting this forum.

Re: CRUD operation with Infopath 2010 from with multiple list data in repeating tables

A.Ishaq — Wed, 10 Jul 2013 10:46:48 GMT

Hi Patrick ,

I really appreciate such a quick response.

I am sorry if the the link does not show an image , please click the following link for the image http://postimg.org/image/88dfdc7kf/

I am able to add repeating table data to a list with custom code, but don't know how to populate the repeating table with the list using code.

Any help would be greatly appreciated.

Best regards.

Re: CRUD operation with Infopath 2010 from with multiple list data in repeating tables

Patrick Halstead — Tue, 09 Jul 2013 23:55:53 GMT

Hi A.Ishaq,

Your link doesn't show an image.

But, anyway, you can map sections to lists using several techniques: CAML, qRules, and possibly BCS.

There are many resources here and on the web. Please take a look at qRules SubmitToSharePointList. Qdabra did a webinar recently showing how to use CAML to do the same thing (out-of-box).

There are many tutorials on MSDN that also show you how to use BCS.

Please do a little search - there's lots of stuff out there.

Thanks!

CRUD operation with Infopath 2010 from with multiple list data in repeating tables

A.Ishaq — Tue, 09 Jul 2013 10:03:31 GMT

Please see the image of InfoPath 2010 from http://postimg.org/image/88dfdc7kf/

The form has three sections(1,2 and 3) as highlighted with blue boxes.
Data of each section will be saved in three different SharePoint 2010 lists.
Data of Section 1 must be saved in the list List_TRFs this list has a primary key ID.
Data of Section 2 must be saved in the list List_Allocated_Budgets so that ID of List_TRFs must also be saved as foreign key with each repeating table value.
Data of Section 3 must be saved in the list List_Destinations so that ID of List_TRFs must also be saved as foreign key with each repeating table value.

What we need:

We need a complete CRUD(Create, Read, Update and Delete) code to manage this form.

User will only see the List_TRFs when he edit the list item, a complete from as shown below must be presented to him, with relevant Budget codes and destinations automatically populated from relevant lists , as a complete from so that he can edit and update the form.