InfoPath Dev

Hi,

Had a search for this but couldn't quite find what I was looking for, so apologies if this has been previously answered.

Using IP2010, I have a standard SharePoint list data connection to a list which looks like this:

 In my form, I want to allow a user to enter a number for each threshold, a modifier (i.e. L,M,H) and for the form to multiply the two numbers together. E.g.

I can filter the List Data Source to get the Threshold A values but I can't figure out how to then return the value of the column that matches the name selected in the Modifier dropdown (i.e. Low/Medium/High)?

i.e. xdXDocument:GetDOM("Thresholds")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:Title = "Threshold A"] gets my the whole row in the list but I want dynamically retrieve the specific column - something like "xdXDocument:GetDOM("Thresholds")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:Title = "Threshold A"]/d:[VALUE OF DROPDOWN]"

Thanks!

p.s. I'm looking for a no-code-behind solution

Hi dw999,

May I ask how do you identify if a number entered belongs to Threshold A, B, or C? For example, does 1-10 belongs to A? And what's greater than 10 belongs to B and so on..?

 Hi Jo-Anne,

 There's no relationship between the numbers the user enters - e.g. they could enter 10 for Threshold A,B and C and select Low for each

 Thanks

Can you try adding a rule in your dropdown that sets your Results field with a value like ../my:ThresholdA * xdXDocument:GetDOM("Thresholds")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Low (where ThresholdA is your text field for entering "A" thresholds), add a condition if Modifier = "Low". Then create the same rule for "Medium" and "High". See if that works.

Ahhh, yes, that would work that way. Thanks!

Does that imply that it's not possible to dynamically reference a field at runtime by it's name without code? e.g. "xdXDocument:GetDOM("Thresholds")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:" + ../myThresholdAModifier

(Similar to the Javascript eval function)