Ticket and Capacity

There is an another column name Reserved you can use this for your 50 seat booked.

Already some seats are booked (Capacity is 300 and 113 seats have been booked, 300 – 113 = 187 left). If I use the ‘Reserved’ column, it will reduce the number of available seats from 187.

However, if possible, I would like the booking system to automatically display 187 out of 300 seats as available. (300 – [number of seats booked]).

https://drive.google.com/file/d/1h3AjC_nmLD5VB8Oe9d99QRWFPXzsVQRC/view?usp=sharing

https://drive.google.com/file/d/1wO0TQ4TWt43K54CucxPwBnEdpaWkAmb0/view?usp=sharing

this image is correct