Advice: Custom Tab

Looking for a little advice here.

I'm creating a custom tab on a performance to replace an external db for tracking House Management information and attendance.

In addition to attendance data by price zone and ticket type (comp, sub, single, group, staff), we also track:

 

PERFID Act2Runtimetime
PerformanceCode EndTime
PerformanceType ShowRuntime
Venue AccessiblePerformance?
GateCount #ofBenefitingPatrons
%Capacity #ofLoopDevicesUsed
PerformanceDate #ofRadioDevicesUsed
PerformanceTime AccessibleSeatsUsed
HouseManager LargePrintProgramsUsed
TicketSalesManager WeatherConditions
UsherTeam OutsideTemperature
#ofVolunteers TheatreTemperature2hrsBeforeDoorsOpen
IfHouseOpenLate TheatreTemperaturePreshow
HouseOpen TheatreTemperature30minsin
Pre-ShowBegin LobbyCondition
Pre-ShowEnd TheatreCondition
Pre-ShowRuntime CoatCheckIncome
Act1Begin PatronNotes
Act1End OperationsNotes
Act1Runtime HousekeepingNotes
IntermissionBegin MiscellaneousNotes
IntermissionEnd PreShow?
IntermissionLength PreShowAttendance
Act2Begin PostShow?
Act2End PostShowAttendance

 

My question to you for the attendance data and the performance information (date/time, etc.), do you suggest we insert that into the newly created table or do you suggest we let the stored procedure simply display and refresh that data every time the tab is opened?

 

Parents
  • Hmmm..  That is also true, but House Management has had a few instances the past two years where they forget about off-line scanning and think they have to tear tickets and wait until they hear from me. 

     

    Lemme think on that a bit.  

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jonathan Smillie
    Sent: Friday, July 22, 2016 3:27 PM
    To: Dot Krebs
    Subject: RE: [Tessitura Technical Forum] Advice: Custom Tab

     

    It seems to me that doing an update to the table regularly would be less overhead – especially because once a performance is over, you wouldn’t expect attendance figures to change much or quickly. The only caveat would be if there are performances for which you are doing after-the-fact scanning, or where scanning on the night doesn’t go as planned and you end up doing a lot of catch-up.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • Hmmm..  That is also true, but House Management has had a few instances the past two years where they forget about off-line scanning and think they have to tear tickets and wait until they hear from me. 

     

    Lemme think on that a bit.  

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jonathan Smillie
    Sent: Friday, July 22, 2016 3:27 PM
    To: Dot Krebs
    Subject: RE: [Tessitura Technical Forum] Advice: Custom Tab

     

    It seems to me that doing an update to the table regularly would be less overhead – especially because once a performance is over, you wouldn’t expect attendance figures to change much or quickly. The only caveat would be if there are performances for which you are doing after-the-fact scanning, or where scanning on the night doesn’t go as planned and you end up doing a lot of catch-up.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data