Sign up form with conditions

[Kanu_Haselhorst]

My Setup:

• SeaTable Cloud (free version)

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.

Is there any way to get this working?

My form:

My table:

[rdb]

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.

You must use two tables.

Take note of the two views in the table “Events”. The view “Only free events” is essential for the following step.

Configure the link column in “Participants” to only display records from a particular view.

Now create your form. In the link column, form users can only select events in the view “Only free events”.