General

Re: Can't get xml to work.

Catharine — Thu, 20 May 2010 16:56:08 GMT

Thank you Jimmy. - Why does the expression box work ?

I have moved on one step now....

I have a secondary data source (GetWhosWho) which has Fields; Region,Role;Email

I have a field whose default value is xdXDocument:GetDOM("GetWhosWho")/dfs:myFields/dfs:dataFields/ns3:GetListItemsStrResponse/ns3:GetListItemsStrResult/Rows/row/Email[../Role = "Regional EVP" and ../Region = xdXDocument:get-DOM()/my:myFields/my:FormCalculationsGroup/my:TopNonBlankRegionalGroup]

My field TopNonBlankRegionalGroup displays a value (Thanks to Jimmy above)

Eg China I have a row in my secondary data source which corresponds to China and Regional EVP - but no value is displayed in my field.

I thought it was because the "China" in my secondary data source was different to the "China" in my field BUT

I have an expression box whose value is xdXDocument:GetDOM("GetWhosWho")/dfs:myFields/dfs:dataFields/ns3:GetListItemsStrResponse/ns3:GetListItemsStrResult/Rows/row/Email[../Role = "Regional EVP" and ../Region = xdXDocument:get-DOM()/my:myFields/my:FormCalculationsGroup/my:TopNonBlankRegionalGroup]

ie identical and the correct value appears in the expression box.

This is truly driving me nuts. My pc will be heading out the window shortly.

Catharine

Re: Can't get xml to work.

Jimmy — Thu, 20 May 2010 12:57:47 GMT

The funky thing about multi-selection list boxes is that default values that reference them only get updated when an item is deselected. In addition to leaving the default value as that formula you have, please try using a rule to set the value of FirstNonBlankRegionalGroup to the value of that formula.

Can't get xml to work.

Catharine — Thu, 20 May 2010 11:52:43 GMT

I have the following data source

SKUIntroductionGroup
RegionalGroup (repeating field) (multi selection box on form)
FormCalculationsGroup
FirstNonBlankRegionalGroup

in the FirstNonBlankRegionalGroup I want to have the first value of RegionalGroup which is not blank.

I have put the default value of /my:myFields/my:SKUIntroductionGroup/my:RegionalGroup[. != ""] and it never displays any value.

I have created an expression box control and put the same /my:myFields/my:SKUIntroductionGroup/my:RegionalGroup[. != ""] in it and it works fine. I think I am going nuts. What have I done wrong?

Catharine