TNEW Checkout Surveys

Jim, everyone; How are you deploying the survey? If you're going through LTR_TNEW_CUSTOM_FORM_DATA to build the questions and generate a CSI through LTR_TNEW_CUSTOM_FORM_SAVE_DATA, you should be able to create a specific keyword for that performance in TR_TKW and associate it with TN_Express_Performance in your TR_TKW_CATEGORY system table. If you're doing a survey of a different kind, the information above might be less handy. Thank you, Brian

Jim, everyone; How are you deploying the survey? If you're going through LTR_TNEW_CUSTOM_FORM_DATA to build the questions and generate a CSI through LTR_TNEW_CUSTOM_FORM_SAVE_DATA, you should be able to create a specific keyword for that performance in TR_TKW and associate it with TN_Express_Performance in your TR_TKW_CATEGORY system table. If you're doing a survey of a different kind, the information above might be less handy. Thank you, Brian

Thank you Brian. I actually found those very instructions and was able to accomplish the mission. :)

Hi Brian, But if you create a specific keyword for a performance and enter it in LTR_TNEW_CUSTOM_FORM_DATA, where will the survey question appear? Are you saying that if we do that, the survey question will only appear if that specific performance is in the cart?

Matthew, When you build surveys through LTR_TNEW_CUSTOM_FORM_DATA, it is a pre-cart survey; the questions that you create will be displayed on the actual item/performance page when the customer is selecting their quantity of purchase. So, whichever items/performances have the keyword that has data associated with it in LTR_TNEW_CUSTOM_FORM_DATA will have those questions show up on the page where the customer clicks to purchase. Any checkout/in-cart surveys would have to be built separately. Thank you, Brian

To follow-up on my response, it is completely possible to have questions show up not on the same page as the item/performance; we've been working with Tessitura on a customization where we don't need the questions to be on the item/performance page but custom survey questions (over multiple pages, if needed) are triggered when the customer decides to check out and has multiple performances set up with those questions in their cart. But this is not something that we would have had the expertise in-house to do ourselves, while LTR_TNEW_CUSTOM_FORM_DATA has a much lower learning curve and barrier to entry if you don't have a SQL/programming guru directly on-staff. Thank you, Brian

And as a final thought for now, definitely check out the latest Sprint 56 Review webinar for TNEW v7 (http://www.tessituranetwork.com/network/Products/Web%20Products%20Roadmap.aspx), especially starting at around the 30-31 minute mark of the video. There's talk of how forms will work differently in the next version.

Hi all, Where in the LTR_TNEW_CUSTOM_FORM_DATA table are you actually entering the keyword? I seem to only be able to associate a TKW Keyword with an Aux Item/Event.

Nick, In LTR_TNEW_CUSTOM_FORM_DATA, the keyword is entered under "Intended Use." If you click on that column in your given row, you'll be able to use a drop-down to access keywords set up in TR_TKW as well as anything you've set up in LTR_TNEW_CONTRIB_TYPE. Thank you, Brian

Brian, that's what I suspected, but for some reason the only options appearing in my drop-down are contribution types, aux keywords, checkout and gift certificate. I'll check in with the TNEW team. Thanks, Nick

I'm not able to access keywords under the Intended Use column either. Is this a TNEW v6 or higher feature? Still on 5.5 here.

Tony, I don't believe it's a v6 feature, though we are on v6 here. Here's the link for the documentation on LTR_TNEW_CUSTOM_FORM_DATA: http://www.tessituranetwork.com/tn_express_web_user_guide/TNEW.htm#Topics/LTR_TNEW_CUSTOM_FORM_DATA.htm Related to Intended Use: The page (Checkout or Gift Certificate), contribution type, or auxiliary item keyword where the custom data field will be used. Options are: Checkout: Displays the field as part of a survey presented to users on the Checkout Payment page. Contribution Type: Displays the field on the Contributions page when users choose the selected contribution type. Pre-configured contribution types populate the dropdown in the format [Organization]:[Contribution Name]. Gift Certificate: Displays the field on the Gift Certificate page. Auxiliary Item Keyword: Displays the field on the Aux Reservations page for performances to which the selected keyword has been applied. The dropdown contains keywords associated to the TN_Express_AUX category in TR_TKW, formatted as KW:TN_Express_AUX:[Keyword Description]. NOTE: The TN_Express_AUX keyword must be applied at the performance level for custom data fields to display on the auxiliary item page. They will not display if the keyword exists only on the production season, production, or title tier. That's going to look awful on this forum without line breaks but it's pretty easily found on the link. Thank you, Brian

Hi Brian, thanks for the info... Is there a live link somewhere to see this functionality?

Tony, Here are some live links from our TNEW showing different forms we have in place for different item types: Annual Fund Donations: https://my.tulsaballet.org/dev/contribute.aspx?don=64&fieldAmt= Gala Event Sponsorship: https://my.tulsaballet.org/dev/contribute2.aspx?don=171&fieldAmt= Adult Ballet Class: http://my.tulsaballet.org/auxiliary/Reserve.aspx?p=3656 Thank you, Brian

Brian, thanks for sharing, those look nice. In our case we were hoping to have the survey functionality only appear in the normal (non Aux) Checkout page only when a specific performance(s) was selected to buy, not for every performance.

Tony, Ah, okay; I haven't been as helpful as I'd hoped then! That'll probably require a little bit of SQL coding in order to trigger form questions based on the presence of a specific item in the cart. If there's a standard way to make it happen in System Tables, it's not something I have particular experience with. Thank you, Brian