I need help in removing or displaying an option in my drop down menu, whenever a criteria is met. So I have a process wherein users can select an appointment window from a list in a dropdown menu. We user an option set to define each of the window in the list (e.g. 8am - 10am; 10am to 12pm, etc.). To prevent users from overbooking within a window each day, I would like to control the number of appointments that can be made within that window daily. That is, whenever appointments booked within a window reaches a certain number, I would like for the that window (in my option set) to either not be displayed on the list of available options that day…or (somehow) the system does not allow them to select that window or progress further. And if necessary, the system could display a message letting them know that the window is no longer accepting appointments.
Any advice/tips will be greatly appreciated.