• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 796
  • Last Modified:

SharePoint - filter a column in OOB SharePoint

I have a MOSS 2007 server.  I'm trying to create a custom list that filters options using only OOB SharePoint.  I also have access to the entire suite of Bamboo web parts.

I want to filter a list based on a column - so that if a user selects an option from column A, only valid entries will appear in column b.  

For example, if I want to associate users (column A) with work types (column B), Joe can do Database, Networking and Security while Paul can do Web Dev, Admin, and Security.  If a user selects Joe, they should only see the options for selecting the values from column B associated with Joe.  These will all be "choice" column types, but I can't find any way to do it without touching the code.
0
armyjack
Asked:
armyjack
  • 2
3 Solutions
 
zephyr_hex (Megan)DeveloperCommented:
this is known as a cascading drop down and there are no OOB filters in sharepoint that do this.

it's possible that the Filter Collection at Bamboo will do this, but their descriptions aren't very in-depth so it's hard to say.  my guess would be that it can't do a cascading drop down.

you can create your own solution or use one that's available on the web (for free):
http://datacogs.com/datablogs/archive/2007/08/26/641.aspx

or buy a solution:
http://www.kwizcom.com/ProductPage.asp?ProductID=709&ProductSubNodeID=710

i know you said you want OOB sharepoint or Bamboo.  if that's the case, then the answer to your question is:  No, you can't do it.
0
 
aspeharCommented:
I think you could achieve what you are looking for by doing an InfoPath form. If you're on MOSS the integration of InfoPath web forms is pretty easy using the form library. You can read more here:
http://office.microsoft.com/en-us/infopath/HP010968041033.aspx
 
0
 
zephyr_hex (Megan)DeveloperCommented:
ahh yes.  i always forget infopath.

here's the steps for creating a cascading drop down in infopath:
http://office.microsoft.com/en-us/infopath/HA011177131033.aspx

i'm not sure if you consider that OOB Sharepoint or not...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now