Newbie Questions

Re: Filtering a Drop Down list inside a repeating table

B4d_k42ma — Mon, 19 Jan 2009 18:08:10 GMT

Actually after looking at these links a bit closer I know how to do what these articles are doing without code, they aren't doing what I'm looking for. To do this without code, what I've done is below.

Set your state equal to what is shown below.

Now, set your 2nd field (usually cities, in my case it's regions) equal to what is below. My webservice it's querying is basically this SQL stmt.

Select description from regions where state_id = @state_id

So I set my Region Field equal to the region description as shown below

And then I set a rule that says that when field1 is not blank, I set @State_ID field in my getRegions query = the state_id in my GetStates query where the state = field1.

The xpath and a pic is below

xdXDocument:GetDOM("MT_getAllStates")/dfs:myFields/dfs:dataFields/tns:MT_getAllStatesResponse/tns:MT_getAllStatesResult/NewDataSet/ReturnedData/state_id[../state = xdXDocument:get-DOM()/my:myFields/my:field1]

Then, add a second step in the rule that queries the GetRegions webservice.

Effectively, you've got cascading drop down lists, or Master Detail with no code needed.

Anyway, You all may have this trick somewhere, but I figured I'd try to contribute..And in the meantime, I'll try and see what I can do about my issue.

Re: Filtering a Drop Down list inside a repeating table

B4d_k42ma — Mon, 19 Jan 2009 16:40:44 GMT

I feared this might be the case, alright. Thanks for links though, they should help..I'll see if I can talk my Sharepoint admin into letting me use Code.

Re: Filtering a Drop Down list inside a repeating table

Anuma — Mon, 19 Jan 2009 16:37:24 GMT

Filtering will not work in the browser forms. So we need to use code to do this.

Re: Filtering a Drop Down list inside a repeating table

B4d_k42ma — Mon, 19 Jan 2009 16:32:08 GMT

Excellent links, the last one and first one are the ones that looks like could solve my problem.

But I forgot to say one thing. I need to try to do this without using any code behind..if possible.

Re: Filtering a Drop Down list inside a repeating table

Anuma — Mon, 19 Jan 2009 16:07:31 GMT

Hi,

Can you verify below links.

http://www.infopathdev.com/files/folders/community_uploads/entry22755.aspx

http://www.sharepoint-tips.com/2007/01/infopath-form-services-implementing.html

http://blueinfopath.blogspot.com/2008/11/cascading-drop-downs-in-infopath-web.html

Filtering a Drop Down list inside a repeating table

B4d_k42ma — Mon, 19 Jan 2009 14:59:13 GMT

I'm running a browser based form in Sharepoint. What I want to be able to do is filter the values of the Drop Down list in the first column so that once a value is selected in one row, it wouldn't appear in the drop down any more in the next row.

I'd like to either have the previously selected values removed from the dropdown list, or be able to apply some validation if the same value is selected twice. Anybody happen to know how to do this or have a really cool trick they could share? Thanks!