InfoPath Dev

UGH, still another problem! When filling out the form, upon opening it in SharePoint, the checkboxes I selected when filling it out are blank and not checked! This is so frustrating! Any help would be appreciated.

I bet it has to do with the rounding in the formulas used to conditionally format and decide what to show in what column...You may need to adjust those based on the counts of the rows returned to get them to line up correctly w/out duplicates...

My replies seem to have gotten a bit out of order. The conditional formatting is causing your issue with the columns. But as far as those checkboxes go....

Here's the thing. You've built this section off a secondary data source with a receive connection. Those checkboxes will always display the value from the data source when the data source is queried. Since you never change the value in the data source... well, those checkboxes will never display as checked. They aren't bound to a field in the Main Data Source of your form, so there is no place to store that information in the form.

You are probably going to need to actually copy the SharePoint information into a repeating element in your main data source. This requires code. We have a free product called qRules that you can also use to do this, if your form doesn't already have code.

I took your suggestion and started using qRules, however, I must be doing something wrong because it's not working properly:

I inserted 3 new repeating tables in the form (Main DS).

Their XPath is (down to the field level):

/my:COBInquiry/my:group7/my:group8/my:field6
/my:COBInquiry/my:group9/my:group10/my:field7
/my:COBInquiry/my:group11/my:group12/my:field8

The XPath of the repeating table which receives my SP list data and the one I want to copy is:

/dfs:myFields/dfs:dataFields/dfs:COBInquiryDataSource/@Title

This is a test run so I am only experimenting with the first table. I set a rule on it:

CopyTable /dsnamesrc=/dfs:myFields /tablesrc=/dfs:myFields/dfs:dataFields /rowsrc=dfs:COBInquiryDataSource/@Title /tabledest=/my:COBInquiry/my:group7 /rowdest=my:group8/my:field6 /empty=yes

That is the 4th variation of the rule because the first didn't work. The fields in the table I'm copying to are set as repeating checkboxes. Hovering over them it says "The selected control cannot repeat here because the field to which it is bound is not part of the correct group..."

I read the qRules guide but it left me unsure. Thanks for any help!

/dsnamesrc should be the name of the data connection that provides your data. That would be what you named it the final step of the data connection wizard and the name you see in the data source task pane drop down list when you select it. /tablesrc looks like it is probably correct. /rowsrc would probably be to the repeating group from your data source, so most likely dfs:COBInquiryDataSource since I'd guess @Title to simply be a field.

/tabledest looks right. /rowdest should be my:group8 withouth /my:field6

Most importantly, your source data and destination data need to have the same number of fields. Be sure your data connection that provides the data is only returning a single column, or modify your destination table to be an equal number of columns.

Ok, the rule on my repeating table (new table, main ds, group9) is now:

CopyTable /dsnamesrc=ReferredBy /tablesrc=/dfs:myFields/dfs:dataFields /rowsrc=dfs:COBInquiryDataSource /tabledest=/my:COBInquiry/my:group9 /rowdest=my:group10 /empty=yes

This table has one field called field7, that is a non-repeating checkbox. I set a rule on it to set its value to the Result field.

When I preview the form, there is still only one checkbox, instead of the multiple it should be displaying. The data source receiving from SP is getting one column (the title of the list item, that's where @Title comes from). So I think my table structures are good, but it still appears to not be working. I'm assuming these commands in qRules can run on load and don't require a button to activate them?

No, I'm afraid they don't run on load....

qRules is not browser-compatible!? When I'm uploading the form template, it says "User interface operations are not supported. Consider removing the following usage: System.Windows.Forms. Location Qdabra.Tools.RulesLibrary.DLL"

So do you suggest I use form code instead to copy the secondary data source repeating table to a main ds repeating table? If so, do you have any code snippets/examples I could look at? Again, I have no clue how to begin.

I'm afraid you are going to have to. Under Tools / Form Options / Programming, set your form to use C#. You'll have a lot better luck finding samples for C# than VB. This is a great tutorial by S.Y.M Wong-a-Ton that should get you started....

I believe I found exactly what I'm looking for, now I'm wondering how to remove qRules from my form template?

You should be able to remove the data connection to Qdabra Commands data source. Adding code to your form will set your new code module as the one the manifest is pointed to (the root assembly). Save your form as source files after adding code, then open manifest.xsf in a text editor. Search for "qdabra.tools.ruleslibrary.dll". As long as there are no references to the dll, you should be able to remove it from the form source files. Open manifest.xsf in design mode again and resave as an .xsn to repackage.