Qdabra qRules

Re: Retrieving Multiple Values from SP Lookup

klink — Tue, 09 Jun 2015 15:42:08 GMT

I'll email it to you, if you promise not to look at it! LOL! It is a HOT MESS right now!

Re: Retrieving Multiple Values from SP Lookup

Hilary Stoupa — Tue, 09 Jun 2015 15:40:31 GMT

Can I just see your form? You can attach it under the options tab or email it to me - I think you have my email address?

Re: Retrieving Multiple Values from SP Lookup

klink — Tue, 09 Jun 2015 15:31:04 GMT

Okay, went back and tried again. Maybe it's my syntax (which would NOT be a shock to ANYONE!)

I have a drop-down box where the user can pick the Objective. When chosen, I query for that record and set the fields. I tried to add the formula where I set fields, but I keep getting errors, and I don't know how to fix it. ='( This formula doesn't get errors when I put it as a rule in multi-selection box. However, it also doesn't fill the fields. Here's the formula:

ObjICPNum = ICPNum[count(current()/preceding-sibling::ObjICPNum) + 1]/Value

XPath - xdXDocument:GetDOM("Site Objectives-By Objective")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ICPNum[count(current()/preceding-sibling::my:ObjICPNum) + 1]/Value

When I try to set the field's value (ObjICPNum) in my "SetObjectiveFields" rules, I get this error:

"preceding-sibling::my:ObjICPNum" does not point to a valid location path of a field or group.

That's where I get stuck. =( I can't figure out how to make it valid... ARGH!!!

Oh, and if you need the XPath for ObjICPNum, it is: /my:myFields/my:Objectives/my:ObjectiveDetail/my:ObjICPNums/my:ObjICPNum

Re: Retrieving Multiple Values from SP Lookup

Hilary Stoupa — Tue, 09 Jun 2015 14:37:55 GMT

The ones that have not been checked should show based on your multi select being set to use the same list of options as your SharePoint list. What is your multi select using for options? Another SharePoint list? Are they hard coded?

Re: Retrieving Multiple Values from SP Lookup

klink — Tue, 09 Jun 2015 13:00:51 GMT

Sorry, I'll try to explain more better! =)

This form will be used to add and/or change an Objective (which includes the ICP#, the multi-choice field). The secondary data source for both the Objective and the ICP# are SharePoint lists.

From the technique you showed in your example, it looks like when I copy the "Value" nodes in from the secondary data source of the "Objective" , the form will only show the ICP#s that the user picked when they added. But I need to also show the ones they didn't pick.

See example. The user first picked #3, 5 and 6 and saved (let's call what they saved Objective 1). If they come back into the form and pick Objective 1 to make changes. I want the ones they checked to still be checked, but also the ones they didn't check to still be there in case they want to check another one. Clear as mud??

Re: Retrieving Multiple Values from SP Lookup

Hilary Stoupa — Fri, 05 Jun 2015 21:52:26 GMT

I apologize, I still don't understand what you are asking.

The technique I showed in the sample could be used to copy your "Value" nodes from your secondary data source into the repeating field in your main data source.

What is your multi-select using for its options? I'm assuming it has the same options as your SharePoint list?

Re: Retrieving Multiple Values from SP Lookup

klink — Fri, 05 Jun 2015 19:52:00 GMT

That is correct!

Re: Retrieving Multiple Values from SP Lookup

Hilary Stoupa — Fri, 05 Jun 2015 19:46:51 GMT

Sorry, I get it now - but you'll only have in "values" from SharePoint the ones that have been selected, right?

Re: Retrieving Multiple Values from SP Lookup

Hilary Stoupa — Fri, 05 Jun 2015 19:45:36 GMT

Sorry, I don't understand. What does "need all of the selections visible" mean? What provides the data source for your multiselect?

Re: Retrieving Multiple Values from SP Lookup

klink — Fri, 05 Jun 2015 19:39:33 GMT

Hmmm. This isn't quite what I had in mind. I still need all of the selections visible, but want to check the ones that are coming in from the SharePoint list. See attached...

Re: Retrieving Multiple Values from SP Lookup

Hilary Stoupa — Fri, 05 Jun 2015 15:25:40 GMT

You can just use insert and a rule on the repeating main data source row to set the value. See attached sample. I don't know if you are using a browser forms or not, but you may need to test this in the browser to verify there aren't any problems there. The insert rule is on the QdabraRules finishedLoading node. :)

Oh - and the sample has a trial of qRules injected - the trial expires 9/15/2015

Re: Retrieving Multiple Values from SP Lookup

klink — Fri, 05 Jun 2015 14:36:22 GMT

Grrr...I'm getting this error:

The table row of the source and destination must contain the same number of elements and attributes. The table row of the source and destination must contain the same number of elements and attributes. Source element count: 2. Destination element count: 1. Source element name list: Value, Value. Destination element name list: my:ObjICPNum.

The multi-selection list box is from a SharePoint list. Not sure if that's a factor.

If this doesn't work, is there a way to concatenate values from datasource into a field and then somehow loop through that field and populate the checkboxes? (Note: Grasping here!)

Re: Retrieving Multiple Values from SP Lookup

Hilary Stoupa — Thu, 04 Jun 2015 21:11:55 GMT

You can check the command overview for syntax when one item is in a secondary data source. The parameter is dsnamesrc if it is the source table.

Re: Retrieving Multiple Values from SP Lookup

klink — Thu, 04 Jun 2015 21:04:27 GMT

Well, I'm pretty embarrassed. I never looked at that form before! Pretty impressive! =) I THINK I get it, but it is not finding the source table. I'm presuming because it is from a secondary data source and I am not identifying it correctly. =/ I'll see if I can find an answer tomorrow, but if you happen to know what I am missing, let me know!

Here's what I have:

concat("CopyTable /tablesrc=/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW /rowsrc=d:ICPNum /tabledest=/my:myFields/my:Objectives/my:ObjectiveDetail /rowdest=my:ObjICPNums /empty=", Empty)

THANKS!

Re: Retrieving Multiple Values from SP Lookup

Hilary Stoupa — Thu, 04 Jun 2015 19:32:19 GMT

Well, you could look at the sample form that installs w/ qRules? It is in the forms folder - the default path is:

C:\Program Files (x86)\Qdabra Software\Qdabra Rules Library\Forms\Installable Forms\qRulesForm.xsn

C:\Program Files\Qdabra Software\Qdabra Rules Library\Forms\Installable Forms\qRulesForm.xsn