Event Capacity & Waitlist Challenge

General
1

Hi everyone,

I want to build an Event Management Platform in Bubble.io, where companies can post events with a limited number of seats.
Attendees can:

  • Register for an event until capacity is reached
  • If the event is full, join a waitlist
  • If a registered attendee cancels, the first waitlisted attendee is automatically moved to the registered list.

The question is:

How can I design the Bubble.io database and workflows to:

  1. Enforce event capacity limits strictly on registrations?
  2. Manage a waitlist queue and automatically promote attendees when spots open?
  3. Notify users when they move from the waitlist to registered status?
  4. Prevent race conditions or overbooking during high registration traffic?

Thanks,
I hope this will be useful for many others as well.