Cascading Dropdowns in Browser Forms

InfoPath 2007 Resources

Miguel Isidoro — Thu, 21 Dec 2006 04:19:44 GMT

InfoPath 2007 Resources

Miguel Isidoro — Thu, 21 Dec 2006 04:19:50 GMT

Encontrei num post do blog do JOPX , este conjunto de recursos sobre InfoPath 2007. General resources

InfoPath 2007 resources, 很貼心的整理

Refines.Info["Polo Lee"] — Tue, 26 Dec 2006 10:28:31 GMT

InfoPath 2007 resources General resources InfoPath General Overview InfoPath team Blog Designing Form

re: Cascading Dropdowns in Browser Forms

bubhat@hotmail.com — Wed, 27 Dec 2006 21:33:35 GMT

I am a newbie in infopath and I have surfed almost every article to get my dependent dropdowns working! Most of the sites ask us to refer this URL.. This is a great article.

I would like to add my comments for populating cascading dropdowns. You can also use repeating tables for this purpose. There is no need to call a webservice on change of each and every dropdown. Just write your logic in the codebehind and populate a repeating table onchange of a dropdown. Bind the dependent dropdown to this repeating table. Ensure to clear the reapeating table on next onchange event of your first dropdown!

-Bhavana Bhat

re: Cascading Dropdowns in Browser Forms

infopath — Tue, 02 Jan 2007 17:36:13 GMT

Hi Bhavana,

Thank you for your suggestion as this is certainly another option! One of the main reasons I used a web service in this manner is that the InfoPath form template (for this functionality) requires no code - as such, the form template does not need to be "Administrator" deployed.

Scott Heim

Filtering in Browser Forms

Inside David's Head — Wed, 17 Jan 2007 04:38:52 GMT

When designing Microsoft Office InfoPath form templates, filtering can be used to limit the options that are displayed to users in certain controls. This out-of-the-box functionality can be used in list boxes, drop-down list boxes, combo boxes, repeating

Filtering in Browser Forms

Inside David's Head — Wed, 17 Jan 2007 04:40:26 GMT

When designing Microsoft Office InfoPath form templates, filtering can be used to limit the options that are displayed to users in certain controls. However, if you are designing an Office InfoPath 2007 form template for a browser scenario, it should

Dependant InfoPath dropdown lists in MOSS

Nick Sevens personal bloggings — Wed, 21 Feb 2007 14:32:48 GMT

One of our customers here asked us to develop a simple InfoPath form, including dependant dropdown functionality.

re: Cascading Dropdowns in Browser Forms

crisch — Fri, 20 Apr 2007 20:52:12 GMT

This is a great example, but what do you do if the controls are in a repeating table? The dependant control (SelectOrder) is "filtered" for every row in the repeating table based on the selected value of SelectCustomer in the current row.

re: Cascading Dropdowns in Browser Forms

Scott Heim — Tue, 24 Apr 2007 15:52:33 GMT

Hi Crisch,

Are you referring to the behavior that when you click the SelectOrder box in an existing row that it only contains the values for the "newly added" row? If so, then correct - this would be expected behavior for this sample.

If you wanted to be able to "refresh" the list when you move to a previously created row, you could add a new column with a button to the repeating table with a Rule that sets the query field and then queries the connection. The only other option may be using managed code but I have not explored that option as I was attempting to show how to accomplish this without using code in the InfoPath form template.

Scott

Huge list of InfoPath 2007 Resources, Links, HOL’s and more

Remember Sammy Jankis — Tue, 22 May 2007 15:51:21 GMT

Hi, I have to admit that this post is long overdue. In the last two weeks, I came across a lot of people

Huge list of InfoPath 2007 Resources, Links, HOL’s and mo

Remember Sammy Jankis — Tue, 22 May 2007 16:12:18 GMT

Hi, I have to admit that this post is long overdue. In the last two weeks, I came across a lot of people

Implementing Cascading Dropdowns in Forms Server

David Airapetyan — Fri, 24 Aug 2007 03:16:47 GMT

The InfoPath Team Blog has a great article on how to implement cascading dropdowns in InfoPath Forms

re: Cascading Dropdowns in Browser Forms

DavidAir — Fri, 24 Aug 2007 03:47:47 GMT

Using managed code, it is possible to set the dropdown values dynamically even in the repeating context. The above URL contains an article on how to do it with a sample.

re: Cascading Dropdowns in Browser Forms

needo — Thu, 06 Sep 2007 17:43:37 GMT

Hello

You are the hero, i was trin to do that from three days without filters but ....

You solved the problem.

Thanks alot.

re: Cascading Dropdowns in Browser Forms

needo — Fri, 07 Sep 2007 10:48:33 GMT

Hello

I have q question.

What if i have 3 dropdown lists. I applied same rule to 1est and 2nd as u did at "SelectCustomer " but its not working, it shows data in first ddl, but no data is selected in 2nd ddl.

Pleaser help

Thanks

re: Cascading Dropdowns in Browser Forms

needo — Fri, 07 Sep 2007 11:04:12 GMT

I solved the above problem it was my mistek. Thanks agin for this article

InfoPath and MOSS 2007 Useful Links

In the Trenches — Sat, 11 Oct 2008 14:47:51 GMT

u How to do custom themes for MOSS http://www.sharepointblogs.com/tigirry/archive/2007/07/03/custom-site-theme-for-sharepoint-2007-moss-2007-and-wss-3-0.aspx

Implementing Cascading Dropdowns in Forms Server

David Airapetyan — Wed, 11 Feb 2009 00:06:29 GMT

The InfoPath Team Blog has a great article on how to implement cascading dropdowns in InfoPath Forms

re: Cascading Dropdowns in Browser Forms

Elliott W — Fri, 26 Jun 2009 01:06:31 GMT

Excellent article! Thanks so much. I needed to populate cascading dropdowns from SharePoint lists in the main site collection, so I just replaced the web service file with this:

<code>

<%@ WebService Language="C#" Class="ListAccess.ListAccessService" %>

<%@ Assembly Name="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"%>

using System;

using System.Web;

using System.Web.Services;

using System.Web.Services.Protocols;

using Microsoft.SharePoint;

using System.Xml;

namespace ListAccess

{

[WebService(Namespace = "http://localhost/ListAccess", Description = "Provides access to SharePoint Lists")]

class ListAccessService : WebService

{

[WebMethod(Description = @"Gets filtered items from the specified list.

Be sure to use the internal name for the filterField.")]

public XmlDocument GetListItems(string listName, string filterField, string filterValue)

{

XmlDocument returnDoc = new XmlDocument();

using (SPSite site = SPContext.Current.Site)

{

using (SPWeb web = site.RootWeb)

{

SPList list = web.Lists[listName];

string queryText = String.Format(@"<Where>

<Eq>

</Eq>

</Where>", filterField, filterValue);

SPQuery query = new SPQuery();

query.Query = queryText;

SPListItemCollection items = list.GetItems(query);

returnDoc.LoadXml(items.Xml);

}

return returnDoc;

}

</code>

re: Cascading Dropdowns in Browser Forms

infopath — Fri, 26 Jun 2009 20:28:46 GMT

Thanks Elliott!

re: Cascading Dropdowns in Browser Forms

pbakker_67 — Tue, 14 Jul 2009 18:10:19 GMT

Hi,

Is there anywhere a walkthrough for this procedure? I'm quite a newbe on this, an on step 2 visual web developpers 2008 express already giving the error: does not support opening Sharepoint Web sites.

re: Cascading Dropdowns in Browser Forms

infopath — Fri, 17 Jul 2009 00:51:22 GMT

Hi pbakker_67,

I don't believe the "express" edition will provide the functionality you will need. I believe you will need a "Professional" level or greater to get the features for this type of functionality.

Scott

Cascading Dropdowns in Browser Forms

InfoPath 2007 Resources

InfoPath 2007 Resources

InfoPath 2007 resources, 很 貼心的整理

re: Cascading Dropdowns in Browser Forms

re: Cascading Dropdowns in Browser Forms

Filtering in Browser Forms

Filtering in Browser Forms

Dependant InfoPath dropdown lists in MOSS

re: Cascading Dropdowns in Browser Forms

re: Cascading Dropdowns in Browser Forms

Huge list of InfoPath 2007 Resources, Links, HOL’s and more

Huge list of InfoPath 2007 Resources, Links, HOL’s and mo

Implementing Cascading Dropdowns in Forms Server

re: Cascading Dropdowns in Browser Forms

re: Cascading Dropdowns in Browser Forms

re: Cascading Dropdowns in Browser Forms

re: Cascading Dropdowns in Browser Forms

InfoPath and MOSS 2007 Useful Links

Implementing Cascading Dropdowns in Forms Server

re: Cascading Dropdowns in Browser Forms

re: Cascading Dropdowns in Browser Forms

re: Cascading Dropdowns in Browser Forms

re: Cascading Dropdowns in Browser Forms

InfoPath 2007 resources, 很貼心的整理