Newbie Questions

Re: Adaptive drop down list based on choices in SharePoint

nwaksmun — Fri, 07 Apr 2017 13:42:46 GMT

Hello, Could you please go into more detail (step by step) of how to do the above? I need to accomplish something very similar for my VP and have not been able to get the desired results. What I'm hoping to accomplish is have one drop down determine what drop down options appear in a second drop down and potentially third. For Example: Drop Down 1: Ideation ---> Drop Down 2: N/A ---> Drop Down 3: N/A Drop Down 1: Project ---> Drop Down 2: High, Medium, Low ---> Drop Down 3: Pipeline, Executing, Monitoring, Radar, Closed The form is linked to a SharePoint library if that makes a difference. Any help would be greatly appreciated. Thanks!

Re: Adaptive drop down list based on choices in SharePoint

Hilary Stoupa — Fri, 31 Mar 2017 23:24:10 GMT

As to the cap - you'd have to check submitted items and get a count. For the cascading dropdowns, you need to associate items in your lists. In your third list, you'd add a column for Worker and for Category (or whatever list 1 & 2 are named), and allow multiple suggestions. Then you'd have the data you needed to filter these successfully.

Adaptive drop down list based on choices in SharePoint

Ozalot — Tue, 14 Mar 2017 14:30:24 GMT

Normal 0 false false false EN-GB X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0cm; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-fareast-language:EN-US;}

I am relatively new to SharePoint and have been tasked to setup a basic event scheduler for a specific event in May. I have start a custom list but am not sure how to set the events to only show when certain items are selected.

e.g.

List 1:

Biology

Chemistry

Maths

Physics

List 2:

Lab Worker

Office Worker

Options:

Monday 1st – 9am to 12pm (Physics and Maths Lab only)

Tuesday 2^nd – 1pm to 5pm (Chemistry and Physics Office only)

Wednesday 3^rd - 9am to 12pm (Maths Office and Lab only)

Thursday 4^th - 9am to 12pm (All Dept Office only)

So if you selected Physics and the Lab Worker you would only get Monday as an option in the dropdown list. While if you selected Physics Office Worker you would get Tuesday and Thursday options in the dropdown list.

Is this possible to do? How?

Also to complicate things, if there were limited places available, how could I set a cap on that up (e.g. Monday had 10 places max available)

Thank you