Club, Venue & Programme template
Venues on a map with capacity, licence expiry and the NACE activity each is licensed for; memberships whose expiry is computed from the join date and term instead of being typed and forgotten; and a programme of dated sessions — classes, fixtures, performances, exhibition openings — with utilisation and ticket revenue computed from attendance against capacity.
Tables
Venues
Venue, Name, Type, Licensed activity (NACE), Capacity, Position, Licence number, Licence expires, Licence days left, Sessions, Sessions programmed, Total attendance, Ticket income, Notes
Members
Member number, Name, Tier, Term, Joined, Fee, Mandate IBAN, Email, Phone, Active, Expires, Standing, Notes
Programme
Session, Venue, Venue record, Venue activity (NACE), Type, State, Date, Led by, Capacity, Attendance, Ticket price, Utilisation %, Ticket revenue, Programming note and 1 more
Views
- Programme calendar (calendar)
- Programme board (kanban)
- All sessions (grid)
- Revenue by venue (chart)
- Upcoming (grid)
- Venue map (map)
- Venue register (grid)
- Membership list (grid)
- Members by tier (kanban)
- Member cards (gallery)
Forms
- Join the club
Automations
- Welcome a new member
- Email the box office on a state change
- Daily renewal reminder
- New record in “Programme”
- “Programme” reached “Cancelled”
- Daily sweep — still open in “Programme”
- “Active” was ticked in “Members”
- Large value in “Capacity”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.