Hello Airtable Community,
I have 2 tables: Attendance and Performances.
People will fill out my ticket request form, submitting their preferred number of tickets for Performance Dates 1,2,3 etc. This gets recorded in the Attendance table under their school name and quantity goes under "Number of Tickets."
I also have a Performances tab that tracks total number of tickets available for the performance. I want to use a rollup or formula to connect the two tables and deduct the total SUM of tickets claimed from a Total Tickets Available number that I set (right now it is 1,000 tickets.)
Ideally I am able to make this appear in both tables: Attendance and Performances. Can you help me?