TNEW_CUSTOM_FORM_SAVE_DATA Question

We are in the process of getting all of our programming into TNew. For some of the workshops we would like there to be a required field on the reservation page. I have successfully gotten this field set up but am very confused by the second half of that where you save the data in the TNEW_CUSTOM_FORM_SAVE_DATA system table. It explains that the procedures are found in TR_LOCAL_PROCEDURE but between myself and my coworker we can't figure out what any of them mean. So at this point we don't know where the data is going to show up. Anyone have any insight?

Thank you ahead of time for your help!

  • Madeline,

     

    By default, the information collected by custom form fields are stored in a CSI on the constituent record.  You have the option to write the information to specific fields by using a custom procedure, but I would use the CSI functionality to start with and determine whether that works for your organization before exploring other options.

     

    For now, bypass the stored procedure columns in TR_CUSTOM_FORM_SAVE_DATA and focus on the CSI columns.  You should create a TNEW specific CSI structure setup and point the columns in the TR_CUSTOM_FORM_SAVE_DATA table to use those CSI settings. 

     

    Here is the link to the documentation for further information.

     

    Thanks!

     

    Becci Brace

    Web Products Implementation Specialist

    Mobile: +1 336 392-2713

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Madeline Dummerth
    Sent: Tuesday, June 02, 2015 8:47 AM
    To: Becci Brace
    Subject: [Tessitura Web Forum] TNEW_CUSTOM_FORM_SAVE_DATA Question

     

    We are in the process of getting all of our programming into TNew. For some of the workshops we would like there to be a required field on the reservation page. I have successfully gotten this field set up but am very confused by the second half of that where you save the data in the TNEW_CUSTOM_FORM_SAVE_DATA system table. It explains that the procedures are found in TR_LOCAL_PROCEDURE but between myself and my coworker we can't figure out what any of them mean. So at this point we don't know where the data is going to show up. Anyone have any insight?

    Thank you ahead of time for your help!




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!

  • Thank you for your response! I'm pretty sure I have now set up CSI categories that will make it much easier to analyze the information.

    Now that I have one of the custom form data pages live there are these giant pink numbers that are partially blocking the explanations. Is there a way to get these to disappear?

  • Madeline -

    Without seeing the page in question or your tables, I would wager your skin may have some formatting issues with the HTML coding you are using, or that is built in to the tables. When I was setting up one of our Aux pages, I repeatedly ran into formatting issues with the radio and checkbox options where data was either overlapping or spacing poorly. The people who handled the skin for the site were able to adjust this for us.

    Thanks,

    Maurice

  • Earlier in the season I set everything up so that when someone registered for our education programming  from our aux page they were required to put in some fields and that was supposed to create a CSI. I have followed everything in the documentation to a T but the information is not creating any CSIs. Anyone have any ideas of what could be wrong?

     

    Thanks so much! 

  • Hi Madeline -

    I'd open up a support ticket about this. They can help look at your setup and verify where a step might be missing. It's always that random check-box somewhere, isn't it? :D

    Best,

    Heather