I have a simple events app with limited spots available. Once the event is full I do not want to take any more bookings
Event: EventID, Name, Location Max Bookings
Event Bookings: EventID, email, Number attending
IFnumber attending + Rollup of Number attending for the same event > Max Bookings THEN Display Message “Event overbooked”
use roll up column to sum attending number, then use visibility condition to hide submit button and display info text, that event is fully booked
This 
That’s what I am trying to do but I cannot get the Max Bookings from the Event table when making a booking
do you have an attending column?
In which table? Events or Event Bookings
In Events I have a Max Bookings and Bookings to date
i don’t know your data set…
once you have total attendance, you can create the if-else column with condition =< MAX booking
My data set is as follows:
Event table with multiple events (EventID, Event Name, Location Max Bookings)
Event Bookings table with multiple events and name of each person (EventID, email, Number attending)
Whenever a person makes a booking check the Max bookings for the selected event
IF number attending + Rollup of Number attending for the same event > Max Bookings THEN Display Message “Event overbooked”
Your example does a rollup on all events not the selected event. How do I get the Max bookings for the selected event
add a new if-else column, that shows only selected events, and sum it
in your case replace the select event with the ID of the event
A user has selected an event to register. The following form is displayed
Form
They then click the attending tickbox
When the form is submitted I want to check if their booking will exceed to Max Number for the event value which is stored in the Event table. I know how to display a message. What I cannot figure out is how to check the Max booking value that is stored in the Events table
you should prevent users from getting to that form… hide the button for that form if the event is fully booked… or create a custom form, using show a new screen action, that you can control, not a native Glide form
Thanks for your help. I will try it out
