Solved

SharePoint Connections Help

Posted on 2013-01-16
17
209 Views
Last Modified: 2013-08-20
I have 3 lists

List 1 values: - Systems, Guides, Help
List 2 fields: - List1 lookup (Systems, Guides, Help)

Systems: - Intel, Server, Unix
Guides: - Install, Support, Troubheshooting
Help: - FAQ, Doc, Forum

List 3 content stores the data of Intel, Server, Unix etc..

How do I make the 3 lists on a page to talk to one another..

Say if a user selects, System, it will popup Intel, Server, Unix. The user then selects Intel.

It will show the content of Intel.

-
How can this be done all on 1 page.aspx
0
Comment
Question by:sharepoint2013
  • 9
  • 8
17 Comments
 
LVL 50

Expert Comment

by:teylyn
ID: 38785677
Hello,

sounds as if you want to do cascading drop-downs (if not, please explain some more). These are not out of the box functionality but can be achieved in several ways:

1. Use InfoPath to edit the list form and create data connections for the drop-downs and filter out what you need.

2. Use the SPServices jQuery library developed by Marc Anderson. It's available on Codeplex here:

http://spservices.codeplex.com/

and the documentation for the cascading dropdowns is in the Docu section here:

Cascading Dropdowns

Let me know which approach you would like to pursue and if you need further detail.

cheers, teylyn
0
 

Author Comment

by:sharepoint2013
ID: 38786644
Please teach me the  SPServices jQuery + Cascading Dropdowns method as I do not have Infopath installed in my org.

Can you teach me how do I use the spservices for my above 3 lists on a page.aspx?
0
 
LVL 50

Expert Comment

by:teylyn
ID: 38790245
Hello,

you need to download the jQuery library, then upload it to your server. In the List form you need to reference the jQuery library and add the script to manipulate the drop down fields.

To edit the list form you need SharePoint Designer 2010. If you don't have that, you won't be able to make these changes.

The SPServices site has exhaustive documentation and samples of several scenarios.

cheers, teylyn
0
 

Author Comment

by:sharepoint2013
ID: 38790408
That's the list form, I'm editing on an .aspx page which I pulled the 3 lists into that.
0
 
LVL 50

Expert Comment

by:teylyn
ID: 38790450
Maybe I have NOT understood what you are trying to do.

From your question:

>> Say if a user selects, System, it will popup Intel, Server, Unix. The user then selects Intel.

>>It will show the content of Intel.

What is Intel? According to your question you have three lists:

Systems: - Intel, Server, Unix
Guides: - Install, Support, Troubheshooting
Help: - FAQ, Doc, Forum

So, if Intel is selected in the Systems list, what exactly do you want to see and where?

Do you want to filter a list view web part? Or are you entering data in another list?

Please provide more detail.
0
 

Author Comment

by:sharepoint2013
ID: 38790479
filter a list view web part.
0
 
LVL 50

Expert Comment

by:teylyn
ID: 38792235
Could you please provide a bit more information?

>> I have 3 lists
>>
>>List 1 values: - Systems, Guides, Help
>>List 2 fields: - List1 lookup (Systems, Guides, Help)

What is the third list?

What are the fields of the list? Field names, column types?

What do you want to achieve?

If you need help with a problem, please provide as much information as you can, especially if you've already been asked twice for clarification. 5 words is not much to go by.
0
 

Author Comment

by:sharepoint2013
ID: 38806777
Sure thing! apologies on the insufficient explanation.

Let me repeat.

List 1 values: - Systems, Guides, Help
List 2 values: - Intel, Server, Unix

List 3 fields are: list1_value, list2_value, description

Example of List 3 values are:
- Guides, Intel,       this is the guide of intel
- Guides, Unix,       this is the guide for unix
- Help, Intel,           this is the help file for intel

--

So now.. I have a page.aspx which allows the user to select a value from List 1 and List 2 and them it will show the description from List 3

How can this be done?

Hope its clear.
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 50

Accepted Solution

by:
teylyn earned 500 total points
ID: 38807814
Hello,

thank you for this explanation. It makes a lot more sense now. So you have a list with two lookup fields from other list and you want to filter the primary list.

You can do that with out of the box web parts. Create a list view web part for the primary list and two filter web parts of the type "SharePoint List Filter". Link the two list filters to the two respective lists.

Then connect the filter web parts to the list view.

See the screenshots

Connect the web parts

setup

Unfiltered list

1

Apply the first filter

2filtered list

Apply the second filter

4result
cheers, teylyn
0
 

Author Comment

by:sharepoint2013
ID: 38808420
where do you get the dropdown filter from?

i'm using SP2007
0
 
LVL 50

Expert Comment

by:teylyn
ID: 38808453
The screenshots are from SharePoint 2010, but filter web parts are available in 2007 if you have the MOSS enterprise edition.

If you don't have that version, there are free solutions available on Codeplex.

http://spvisibilityfilter.codeplex.com/

http://dropdownsharepoint.codeplex.com/
0
 

Author Comment

by:sharepoint2013
ID: 38866724
Do you have code samples for SP2007
0
 
LVL 50

Expert Comment

by:teylyn
ID: 38866749
I don't understand that latest question.

What license of SharePoint 2007 do you have? As I said above, if you have Enterprise, then you will have the filter web parts. If you don't have Enterprise, then you can get the free web parts from Codeplex.

Where do code samples fit in all this?
0
 

Author Comment

by:sharepoint2013
ID: 38866846
it's Standard.
0
 
LVL 50

Expert Comment

by:teylyn
ID: 38866893
Ok, so that means you don't have filter web parts out of the box. The free (free!!) Codeplex web parts are the way to go.

It may be daunting at first to delve into this, but if you want functionality that is not included in your license, then you'll have to bite the bullet.

Don't shoot the messenger.
0
 

Author Comment

by:sharepoint2013
ID: 38934496
Will try this out.
0
 

Author Closing Comment

by:sharepoint2013
ID: 39424045
Awesome solution!

As mentioned above i'm using sp2007 standard and do not have access to central admin to deploy codeplex webparts, how do i create the dropdown list webparts in designer?
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
Introduction JSON is an acronym for JavaScript Object Notation.  It is a text-string data transport mechanism, capable of representing simple or complex data structures in a consistent and easy-to-read manner.  Similar in concept to XML, but more e…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now