Newbie Questions

Re: Retrieving SharePoint lookup data based on a form field selection

dw999 — Wed, 11 Jan 2012 09:42:14 GMT

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)

Re: Retrieving SharePoint lookup data based on a form field selection

Jo-Anne Alfafara — Wed, 11 Jan 2012 09:24:32 GMT

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.

Re: Retrieving SharePoint lookup data based on a form field selection

dw999 — Wed, 11 Jan 2012 08:36:22 GMT

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

Re: Retrieving SharePoint lookup data based on a form field selection

Jo-Anne Alfafara — Wed, 11 Jan 2012 05:06:53 GMT

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

Retrieving SharePoint lookup data based on a form field selection

dw999 — Tue, 10 Jan 2012 21:55:22 GMT

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:

Title	Low	Medium	High
Threshold A	0.1	0.3	0.5
Threshold B	0.2	0.7	1.0
Threshold C	3	6	10.0

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.

	Value	Modifier	Result
Threshold A	[NUMBER FIELD] e.g. 10	[DROPDOWN FIELD] - contains Low, Medium, High e.g. Medium	[CALCULATED FIELD] - Value * Matching Modifier against the lookup for Threshold A (e.g. 10 * 0.3 = 3)

Value

Modifier

Result

Threshold A

[NUMBER FIELD]

e.g. 10

[DROPDOWN FIELD] - contains Low, Medium, High

e.g. Medium

[CALCULATED FIELD] - Value * Matching

Modifier against the lookup for Threshold A

(e.g. 10 * 0.3 = 3)

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