Browser Forms

Re: how to split up results in a repeating table, in a browser-enabled form

Hilary Stoupa — Fri, 24 Apr 2009 00:32:25 GMT

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.

Re: how to split up results in a repeating table, in a browser-enabled form

rippedX — Thu, 23 Apr 2009 23:24:01 GMT

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

Re: how to split up results in a repeating table, in a browser-enabled form

Hilary Stoupa — Thu, 23 Apr 2009 23:22:05 GMT

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....

Re: how to split up results in a repeating table, in a browser-enabled form

rippedX — Thu, 23 Apr 2009 23:06:51 GMT

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.

Re: how to split up results in a repeating table, in a browser-enabled form

rippedX — Thu, 23 Apr 2009 23:04:34 GMT

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"

Re: how to split up results in a repeating table, in a browser-enabled form

Hilary Stoupa — Thu, 23 Apr 2009 23:01:27 GMT

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

Re: how to split up results in a repeating table, in a browser-enabled form

rippedX — Thu, 23 Apr 2009 20:20:02 GMT

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?

Re: how to split up results in a repeating table, in a browser-enabled form

Hilary Stoupa — Thu, 23 Apr 2009 20:00:19 GMT

/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.

Re: how to split up results in a repeating table, in a browser-enabled form

rippedX — Thu, 23 Apr 2009 18:00:53 GMT

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!

Re: how to split up results in a repeating table, in a browser-enabled form

Hilary Stoupa — Wed, 22 Apr 2009 20:43:11 GMT

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.

Re: how to split up results in a repeating table, in a browser-enabled form

Hilary Stoupa — Wed, 22 Apr 2009 20:34:11 GMT

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...

Re: how to split up results in a repeating table, in a browser-enabled form

rippedX — Mon, 20 Apr 2009 22:34:42 GMT

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.

Re: how to split up results in a repeating table, in a browser-enabled form

rippedX — Mon, 20 Apr 2009 19:13:23 GMT

Now a new problem has come up...When I add a new item to my SharePoint list (Test Item 1), a duplicate checkbox is inserted on the form as you can see below.

However when I insert 2 items to the list, the duplicate goes away.

Any idea why this is happening?

Re: how to split up results in a repeating table, in a browser-enabled form

rippedX — Mon, 20 Apr 2009 02:17:29 GMT

Well I seemed to have solved the problem. I created a new lookup column in my SharePoint list which I linked to the Title column, unbound. Then I changed the xpath expression box which was serving as the title of the checkboxes on my form, to reference this new field. Now it doesn't change when they are clicked.

Re: how to split up results in a repeating table, in a browser-enabled form

Hilary Stoupa — Mon, 20 Apr 2009 00:48:53 GMT

Ah, so you have check boxes bound to the @Title field from the ShP list. What do you want to have happen when the checkbox is selected (aside from *not* changing the title to 'yes')?