We have a number of organizations that would like to leverage some of the new application and TNEW functions and get away from the customization they use for education registrations. Is anyone on v15 and TNEW v7 using out-of-the-box functionality to gather student information and provide their education departments with good reports (bonus if you're in a consortium)? If so, we'd like to hear what works for you!
Thanks in advance from Kalamazoo -
We just moved our Comm Ed department onto Tessitura and are using (almost) everything out-of-the-box. We are use Aux item form fields to collect CSI info for School Shows when teachers register on TNEW and are using a Custom SSRS Report that Heath Wilder wrote that takes the TNEW CSI notes field and turns it into columns for each question and can be saved as an Excel file. We also have standard ticket and Title I tickets broken out by Price Type for reporting: If you want to see the TNEW page for this year's virtual Nutcracker school shows, it's here: https://my.balletaustin.org/overview/nutzschool2020
We're also planning on using the same plan as Jamie with a Triggered Campaign and Pages Survey to collect data for other Comm Ed products that we haven't started booking live yet, like studio tours and docent programs, which just have too many variables and questions to reasonably put into TNEW forms. When we get there, I'll probably need to fudge the CSI report SQL some because the TNEW CSIs and the Pages CSIs use different delineaters between questions! But... that's a problem for later me.
Is this a report you'd be willing to put in th shared reports? I know my education would love this customization!
Fine by me! Heath Wilder, that alright with you, since you wrote it? Gregory, what's your email? I can also send it to you directly.
Yeah that's fine.
BUT as its a mondo CTE I'm sure clever people can improve it. If you do please let me know. It was a lot of sleepless nights