Hi all,
For time immemorial, our FOH managers have issued via email a word doc at the end of each night regarding the performance with all of the typical data - actual house open and perf start times, house temperature checks, weather, concessions/ancillary sales during intermission, customer comments, etc. I want all of that data in Tessitura so it's retrievable and we can analyze it against/between productions.
I was thinking of creating a custom tab that would live on the perf level in Ticketing setup, and then building a report based off of that that could be scheduled and auto-emailed and then also related list criteria, output elements, etc. My concern, though, is making this easy for our FOH managers as well as not really wanting to grant access to ticketing setup to anyone other than show builders (as form data entry would have to be entered at the perf level each night). Has anyone else built this kind of report recently? Where did you set the data to live so that FOH could do their data entry?
Thanks!Kathleen
Something I thought of this morning - since I'll have to have a local table to store this data anyway, I can always expose it in the system tables area of the client. It would be very easy to limit access to just that table for data entry purposes until I figure out the best place to do something with a friendly UI (maybe a web screen of some sort).
Arts Centre Melbourne did a ANZTRUC presentation in 2018 on setting up custom System Tables for Education to record their bookings etc. It was pretty great and served them well. I might have the slides on me.
Ooh, I'd love a peek at them if it's not too much trouble!