How to create cascading dropdowns / auto fill with sharepoint

Posted on 2011-03-01
Medium Priority
Last Modified: 2012-05-11
I have a form that has four fields.  At this time I have it pulling the data from four seperat list - which I'm not certain is the best way to do it.

Here is what I've referred to when building it. The problem is that I don't need a lot of seperate list, and two of the fields needs to be auto filled and the user should not be able to edit them.

field "a"  
field "b"   multiple options based on field "a"
field "c"   auto fillled based on field "a"  // needs to be uneditable
field "d"   auto fillled based on field "a" // needs to be uneditable

Any help???, please!
Question by:InvAutomation
  • 2

Accepted Solution

Deathrace earned 1000 total points
ID: 35009017

Assisted Solution

rebejones earned 1000 total points
ID: 37542722
I would use spservices by marc Anderson. Http://spservices.codeplex.com from there check out the Getlistitem and or cascadedropdown. Read the documentation and look at examples. If you need more help I can write you a sample script. I did something similar to you using spservices getlistitem to pull from the other list and then based on that value it would populated the rest of the fields and then I set the fields as read only with some javascript.
LVL 12

Expert Comment

ID: 37693389
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

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 …
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
Suggested Courses

600 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