Data collection forms & Tessitura

Hello Brain-Trust.

I need you to pull me out of my tunnel vision. We have been toying with the idea of using TNEW to book student matinees and I am struggling with the challenges of doing that. Between our business rules (tickets are booked under the school and not the teacher) and the TNEW ticket limits, it is not as simple as I would like. While trying to find the answers to those questions, I believe I may have gone down a rabbit-hole and I am not looking at all the options available to us.

With that all of that said, it seems what we are actually trying to achieve is surveying the teacher about their request instead of actually booking a seat or a performance.

Some things you should know ->

We are WordFly client

Currently on TNEW 6 AND V.15.0

Tinkered with CSI's and custom form data

There are different if, then, else clauses based upon production choice

There are stock questions we want to only ask once if someone is booking more than one production

The person making the request is required to accept terms & conditions

I'm not opposed to a custom form on the constituent for data collection

Best case there would be a calculated field.

Up until this point, we had a gravity form on a website that is at EOL.  Ok... Ok... It's looking at EOL in the rear-view mirror and getting so tiny we can no longer see it.

Any and all thoughts and advise is appreciated. 

Dot

  • Hi Dot, 

    We wanted to use Custom Forms to collect this reservation inquiry information, but we ultimately ended up using Google Forms integrated into our Wordpress Page instead. To use Custom Forms, you have to have a performance set up, which turned out to be confusing for this type of situation. Given the exact limitations you outlined in regards to booking these kind of events, we found that submitting an inquiry through Google Forms and then having a team member call them to place the actual reservation was best for us. Here's our webpage if you want to take a look at our form: https://www.operacolorado.org/education/field-trip-opportunities/

    Best,
    Michelle

  • You should not need to use a third party to accomplish this. In fact, I wouldn't even consider it due the extra work involved if the data needs to get back into Tessitura. If it is just for contact survey maybe using validate cart or share sessions will work for you. Here is an example on how I would tackle this ...

    1. Send directly to a validate point and pass the production no a variable maybe from drop down list. (Landing page asking for production of interest from a selection and next button)

    2. Have validate cart direct traffic based on the selection. Shoot them to the appropriate form with you validity test.

    3. When the form is submitted insert into a local table. 

    4. From there you can do what ever you want. Create a report, create a CSI, etc

    You could have the last field of the form be terms and conditions for initials and accept checkbox. This could log the initials and the checkbox value with a timestamp.  

    I could probably whip a basic example using validate cart for you on our test site in the couple days if you want to see the potential. The shared session would require a bit more work, but I can show you an example in a couple weeks when camp goes on sale.

    Travis