I’m looking to build a system where an individual can select their name from one dropdown, then enter a date, and from there, a second dropdown will populate with a list of professors who are available to arrange a meeting with. In order to cap the number of attendees, once a professor has been selected for a given date 10 times, their name will no longer show up in that second dropdown for future rows. Is this possible?
Hi @ACD ! Welcome to the community !
It should be possible
Without more info about your doc, this is a little something you should be able to play with to get the desire result .
There are 2 different examples in this doc that work together :
Prof [Lookup] 1and
Lessons [Lookup] 1
Prof [Lookup] 2and
Lessons [Lookup] 2
There might be other ways to do this though : It’s just an idea
That did the trick. Thank you!
@ACD Lol I’ve withdrawn my post earlier because it didn’t completely answer your problem and I’m actually looking at a more complete solution .
Edit : Just in case this is my final take on this
Select List than
A little bit more complex but it seems to do the work this time