When creating an event in a calendar, I list 4 standards for the creator to choose from. I want the chosen standard to then trigger a drop down of locations for that standard. Can I do this?
For example I list 4 buttons to choose from:
SFI Standard: - FM - FS - CS - CoC
and based on which button they check, ONE of the below columns will appear with a drop down of corresponding locations
FM:Locations FS: Locations CS: Locations CoC: Locations
First, I'm going to make some assumptions:
If those assumptions are correct, here is what I would do:
Create 4 separate lists in the same site as the Calendar: 1a. FM Locations Lookup 1b. FS Locations Lookup 1c. CS Locations Lookup 1d. CoC Locations Lookup NOTE: For this example, just use the Title column of each of the above lists to store the Location value.
Create 4 new Columns in your Calendar, each of which is a Lookup to one of the above lists. The value will come from the Title column of each of the above lists.
Edit your New Item Form in your Calendar, and place the 4 Lookups you just created on the Form where you would like them to show.
Click on any one of them, and click Manage Rules.
Create a Formatting Rule for each Lookup control similar to the following (let's use FM as an example): 5a. Condition: If SFI Standard does not equal FM. 5b. Action: Check the box that says "Hide this control".
The result of the above will be as follows:
When a user creates a new Item in the Calendar, none of the 4 Lookup columns will be visible (assuming there is nothing in SFI Standard yet). Once a user selects a value for SFI Standard, the correct Lookup will show. The lookup will contain the data from the list you connected it to when you created it.
Please let me know if I can provide more details.
