I would like to set up a form for our kayaking club where members can sign up for a certain date for their cleaning duties. I currently have the available dates as single options inside a dropdown.
What I want to achieve:
When two members sign up for a date, then this date should no longer be available for other members to pick.
Yes, this is possible. The solution can be implemented through the clever combination of a link column, a formula column for links and a filtered view.