Hi I was wondering if anyone knew of a way of filtering a list when adding a new item to a list. Example would be if I have two lists, the first called Subsectors with two columns, Sectors and Subsectors. In this list I would have data like A, B, and C in the Sector column and in the Subsector column I would have data like A1, A2, A3, B1, B2, B3, C1, C2, C3.
The second list would be called Sectors, with two lookup columns that look at the columns in the Subsectors list. What I am trying to figure out is when I add a new item to the Sector list, I want to choose the Sector in this case A, and when I then choose the Subsector, I just want to see A1, A2,A3, so basically it is filtered on the fly. In a previous life a long time ago I used to do some programming in Delphi using Paradox tables. In this case I would have had an onclick event occur when I made a chose in a combo box and then filter the table. Not sure how to do this in SharePoint as I do not do much coding within SharePoint.
Just found this http://www.azu.mn/2013/10/lookup-plus-for-sharepoint-2013-cascading-cross-site-filtering.htm . I presume that this means there is no OOTB way of doing it.
Any help I would be very grateful.
I understand where you are coming from… I have done a lot of work in SharePoint and I have never found a way that this could be done. I don’t know of any way to filter a lookup column results without writing custom code…
Given that is the case, I would probably use JQuery or something of the sort to update the dropdown or, as you noted, hopefully find a good plugin that can handle it.
Sorry I couldn’t offer much more than that.
There is no OOTB way to get cascading dropdowns. I have successfully used the SPServices jQuery library to implement this though.
You can customize the List InfoPath form and this would be the easiest/OOTB way to achieve cascading dropdowns in for a list item.
Second option is to use javascript on NewForm.aspx and DispForm.aspx of the list
http://www.markrackley.net/2014/05/20/cascading-drop-down-lists-in-sharepoint-office-365-using-rest/
Out of the box, with no code, you can’t do this. I have done this using Infopath, but most people stay away from Infopath. I think you can use javascript but I don’t know how.
