How to build a ticket booking system in Bubble

Go to the Data tab. Create a Data Type called Event with fields: Title (text), Description (text), Date (date), Venue (text), Cover Image (image), Total Tickets (number), Tickets Sold (number, default 0), Price (number), and Is Active (yes/no). Create a Data Type called Ticket with fields: Event (Event), Buyer (User), Buyer Email (text), Quantity (number), Total Price (number), Status (Option Set: Held, Confirmed, Cancelled), Hold Expires (date), Ticket Code (text), and Purchase Date (date).

Create an events page with a Repeating Group showing active events: Do a Search for Events where Is Active is yes, sorted by Date ascending. Display Cover Image, Title, Date, Venue, Price, and an Available Tickets count (Total Tickets minus Tickets Sold). Create a dynamic event page with Type set to Event that shows full details plus a Book Tickets section with a number input for quantity and a Book Now button.

When a user clicks Book Now, first check availability: add an Only when condition that Quantity Input's value is less than or equal to (Event's Total Tickets minus Event's Tickets Sold). Create a new Ticket with Status set to Held, Hold Expires set to Current date/time plus 10 minutes, and the selected quantity. Simultaneously, update the Event's Tickets Sold by adding the quantity. This holds the tickets for 10 minutes while the user completes payment. Create a Backend Workflow called release-expired-holds that runs every minute, searches for Tickets where Status is Held and Hold Expires is less than Current date/time, changes their Status to Cancelled, and reduces the Event's Tickets Sold by the cancelled quantity.

After creating the held ticket, redirect the user to a checkout page or show a payment popup. Use the Stripe plugin's Checkout action to create a payment session with the total price (quantity times event price). On successful payment (Stripe's payment success event), update the Ticket's Status from Held to Confirmed, set Purchase Date to Current date/time, and generate a unique Ticket Code using a random string or the Ticket's unique ID. If payment fails or the user abandons, the hold timer will automatically release the tickets.

After confirming the ticket, send an email to the buyer. Include the Event Title, Date, Venue, Quantity, Ticket Code (which serves as the entry code), and a formatted HTML email with the ticket details styled as a digital ticket. For a QR code, use an API like goqr.me to generate a QR image from the Ticket Code and include the image URL in the email body.

Create a page called verify-ticket. Add an Input field for the Ticket Code. When the staff member enters a code and clicks Verify, search for a Ticket where Ticket Code equals the input value. If found and Status is Confirmed, display a green success message with the buyer name, event, and quantity. If not found or Status is Cancelled, show a red error message. Optionally add a Check In button that marks the ticket as used to prevent re-entry.