Here at LSC, staff have just been notified, and we have notified customers, that we are shut down for the rest of March.
https://lsc.org/update-regarding-covid-19
I've seen articles in the press that the MET Museum and MET Opera are shutdowns. This is likely related to New Yorks shutting down of gatherings of more than 500. https://gothamist.com/arts-entertainment/cuomo-shuts-down-broadway-limits-public-gatherings-under-500-people
We've canceled performances through March at the urging of our Governor and Mayor. I did exactly what Heath did and set up a survey for our patrons to hopefully cut down on box office calls. We've been given the option to work from home, but the office is open for now.
Be great to see the front end/back end of surveys for reference. We have wordfly but have yet to implement it since we just came online last fall.
We chose to do one form per production because our shows are very spaced out. Here's a front-end example: https://michiganopera.org/dth-cancelation/ There's also a fillable PDF that's downloadable if people are more comfortable with that, and we're mailing copies to everyone as well.On the back end, these are emailed to a dedicated cancelation inbox that our box office team has access to and can be downloaded in an Excel file in bulk. Ours is made via a Ninja Form on the Wordpress half of our website. There's an automated confirmation to the patron that provides them a copy of their request as well.If I'd had more time than the two hours I did have, I would have wanted to put these straight into CSIs. It just wasn't feasible - the announcement was very sudden. We had students in the hall for a rehearsal as schools were announcing shut downs.
My page is still in draft but I'm happy to email you the link for personal viewing until it goes live.
The great thing about WordFly Pages is that is saves the response with a Customer Number against it in the database.
I've also got a simple Surveys/RSVPs SSRS report that I can share if anyone needs it. It links and exports the 4 WF tables with customer name as excel.
Heath Wilder, If you have a chance. It would be helpful to share the Pages Survey SSRS Reoport.
cc: , Mark DuBose
Here's the SProc the RDL and a Test example
Enjoy
SDC_WF_Page_Response.xlsx
drive-download-20200315T093030Z-001.zip