Help Setting Up Conditional Booking Form with Availability Logic

Ask the community
,
1

What I’m trying to do:

  • Parent logs in and sees a form to book swim lessons for their child(ren).
  • The form includes dropdowns for:
    1. Day Combo (Mon/Wed or Tues/Thurs)
    2. Location (Turlock or Modesto)
    3. Time Slot — should only show sessions that:
    • Match the selected day + location
    • Are not fully booked (I have a “Fully Booked :white_check_mark:” checkbox in Airtable)
    1. Swimmer — should only show swimmers linked to the logged-in parent

My setup:

  • Airtable table: Sessions (includes day, location, time, instructor, availability)
  • Airtable table: Swimmers (linked to the parent in User Accounts)
  • Airtable table: Bookings (form is connected here)
  • All sessions are pre-created in Airtable

What I need help with:

  • How to set up Softr’s conditional logic to filter sessions based on the selected day/location + not full
  • How to filter swimmers to only show those linked to the logged-in parent

If anyone has done something similar (or has a clever workaround), I’d love your insight or even a quick screenshot of how you set it up. Thanks in advance :pray:

— Sydnee