InfoPath Dev

Hi,

I have just started using qRules so am still a novice.  I have a repeating table that I want to contain information from queried data in my secondary source.  I want to be able to add and or edit the data, and then be able to save the data in my repeating table back to my Sharepoint list.  Is there a way to do this with qRules or otherwise?

 Thanks in advance,

Kelly

Yes, the general steps would be the following:

1. Create your secondary data source to retrieve data from your SharePoint list. (no qRules) You will need to make sure you bring in the ID field.

2. Look at the data source brought in by InfoPath. Now create your schema in the main data source, so that the fields match the secondary data source.

3. Copy the data from the secondary to the main data source by using the CopyTable command.

4. Create the SharePoint list mapping. Hilary has a good series of blog posts on this, linked from here. Make sure to use the /id parameter so that the existing items are overwritten. The new items won't have an ID, so those would get added to the SharePoint list by the qRules command.

We also have free qRules training available here.

The full list of qRules documentation can be found here.

Hope these help!

Thanks Ernesto. 

 Is it possible to use the insert command as well?  I was watching Hilary's video Copy Complex Repeating Data and thought that might be suitable to use as well

1. I queried the Secondary data source which is a Sharepoint list, then used the Insert command -> concat("Insert /parent=/my:myFields/my:ProjectDetail /child=my:group4 /count=", count(SharePointListItem_RW))

2. varCounter = count(node) +1

I have trouble using count(preceding-sibling::node)+1.  Do I just type that in the value of my set field?

Thanks.

Kelly

Hi Kelly,

Yes, you can use Insert and SetValue. We have that scenario documented here with step by step guidance. Hope it helps!