Cascading Lookup Site Columns
Something that I feel is still missing from SharePoint to this day is to create a Lookup Site Column that gives a different set of options depending on another Lookup Site Column. To give the set of steps on how this would work:
- User clicks on a lookup field for example called "Country" and selects "United States".
- A field for example called "City" now gives a set of Cities within the United States, whereas if the user selects "Germany" for example it would select all cities in Germany.
- The user selects a City for example "Chicago" and a 3rd lookup field would now give a list of Counties in Chicago.
I realize this can be done with CSOM and a custom development solution, but doing it with CSOM does not translate into the same functionality when for example a user is trying to add a document in Microsoft Office and save to SharePoint. The Meta Data that is capture in that case would not have the Cascading dependency.