none
SharePoint Cascaded Lookup Dropdowns columns RRS feed

  • Question

  • Can we create cascade dropdown list in SP 2010 without relying on 3ed party tool to avail all the features. our requirement is if a certain value is selected in the parent column, different options get filtered in the child column. In the parent column, we have different options and so in Child column. Thanks !!
    Wednesday, January 18, 2012 4:07 AM

Answers

All replies

    • Proposed as answer by Batiste Rouelle Monday, January 23, 2012 7:58 AM
    • Marked as answer by Wayne Fan Thursday, January 26, 2012 10:05 AM
    Wednesday, January 18, 2012 5:06 AM
  • Thanks for sharing above info.

    One more query.

    Parent Column Option:

     A

    B

    C

    Child Column

    Date: MM/DD/YYYY - Calendar

    When someone select option C, child column (date) should be highlighed to enter the dates.

    Since I am new in SP hence asking these basic questions. Thanks!! 

     

     

     

    Monday, January 23, 2012 7:21 AM
  • Hi you could again use javascript to achieve this. Find below a sample implementation (This is just a pointer you might need to modify/tweak as per your requirement

    Hope this helps!!!

    <script type="text/javascript">
    function getField(fieldType,fieldTitle) {
        var docTags = document.getElementsByTagName(fieldType);
        for (var i=0; i < docTags.length; i++) {
            if (docTags[i].title == fieldTitle) {
                return docTags[i]
            }
        }
    }
    
    function processChild() 
    {
    //implement your logic enable/disable or show/hide Child column based on your value
    
    }
    
    //allocate dynamic event to your parent Field
    getField('select','Parent Column').onchange = function() {processChild()};
    
    </script>
    
    



    My SharePoint Blog
    http://www.dhirendrayadav.com
    Monday, January 23, 2012 8:43 AM
  • It seems I should start learning Java/InfoPath/VS since SP is all about these technologies. I dont have any exposure in any of these and making me to find a shortcut in SP itself, but it is taking so much time.

    But i dont get this why MS has not included these basic features in Workflow, since it is required usually while creating any workflow. It should be kept as simple so that any layman having basic understanding of MS products could create a simple workflow atleast.

    I was under the impression that working in SP Designer would be pretty easy, but i am finding it very complex even to create a simple workflow or are these not so simple since i am creating this the first time...

    I've also posted 5-6 question in other categories as well, and simple queries, not complicated at all..but again, without Forum, difficult to find a fix of them, Also couldn't fine any good docs on workflow..

    Your comments :) 


    • Edited by sachin1361 Tuesday, January 24, 2012 7:12 AM
    • Marked as answer by Wayne Fan Thursday, January 26, 2012 10:05 AM
    Tuesday, January 24, 2012 7:11 AM
  • Sachin, you can create cascading dropdowns in a SharePoint 2010 list _IF_ you convert it to InfoPath.  Then, it works out of the box.  If not, then it requires code, which is more complicated.

    Below, you said you were just trying to do something simple with workflow, but your question here has nothing to do with workflow.  Maybe you were just venting about other topics.


    SharePoint Architect || Microsoft MVP || My Blog
    Planet Technologies || SharePoint Task Force
    • Marked as answer by Wayne Fan Thursday, January 26, 2012 10:05 AM
    Tuesday, January 24, 2012 7:28 AM