2

How can I populate 2nd choice column based on the 1st choice column?

For ex.: 1st column, 1st option - Veg Food, 2nd option - Non-Veg Food. If the user selects Veg Food option, then in the second column will be shown choices A,B,C. If user chooses Non-Veg Food, then in the second column will be shown only choices X,Y,Z

I don't want to use any code to have this change. I have an access to Designer and InfoPath.

4

You can achieve cascading in SharePoint through multiple ways as the following.

  1. Using javascript SPServices.SPCascadeDropdowns.
  2. Using Infopath data connection and some rules. by the way, this option requires SharePoint Enterprise Edition
  3. Develop a Custom Field using C#.

Based on your knowledge you can select the preferred option.


Here I will show to you the first options using SPServices.SPCascadeDropdowns,

  • Open your list,

  • From the above ribbon, select Default New form,

enter image description here

  • Add a new Script Editor web part

  • Add the below code by specifying the parent and child lookup field

Script:

<script src="https://site name/jquery.min.js"></script>  
<script src="https://sitename/jquery.SPServices.min.js"></script>  
<script type="text/javascript">  
$(document).ready(function ()  
{  
    $().SPServices.SPCascadeDropdowns(  
    {  
        relationshipList: "Column2",  
        relationshipListParentColumn: "Column1",  
        relationshipListChildColumn: "Title",  
        parentColumn: "Column1",  
        childColumn: "Column2",  
        debug: true  
    });  
});  
</script>  

For the detail, steps check

0

It sounds like a case for Dr. SharePoint Hillbilly

http://www.markrackley.net/2017/03/06/new-improved-cascading-dropdowns-for-sharepoint-classic-forms/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.