Scenario: 2 lists, List 1 is a custom list (Registrations) and List 2 is a Calendar of Training Sessions.
I am limiting attendance to 20 people per training session. List 1 has the same lookup column appearing twice (displays the Session Names from List 2), displaying all 6 available session dates allowing each user picks a first and second choice from among the same group of sessions.
List 1 default view is grouped by Session date as first choice (the first lookup column value chosen). I have set the view to display the total number of items in the group using "totals- count" in the "modify this view" option, so I can easily see how many have chosen a particular session as a first choice.
List 2 (calendar) defaults to "Training Session Event" content type in which I added an "attendance" column, limited to a number- minimum value zero, maximum value 20. It also has a "capacity status" choice column, with 2 available values: "Open" (default) and "Full."
Ideally, i can run a WF that goes between these 2 lists, such as: As items for a session date as first choice are added to List 1, the value in the calendar (list 2) "attendance" column increases by 1. Once it hits 20, the status changes from "open" to "full."
At that point I am not sure what could automate; I would be happy with an email telling me the count maxed out and I would manually go in and begin scheduling the rst of the users by their "second choice" option they had selected.
Or-
- Condition: If the count of items grouped by "Session 1" is less than 20;
- Action: Do some action...
- Else: Do another action...
Could any of this be managed in SPD? Please don't suggest any other solutions like VS or other coding; I don't have anything resources but SPD at my disposal. Thank you!!
