Our organization is planning to use our TNEW Auxiliary page to sell drinks, and we'd like to use the custom_form_save_data to allow our patrons to identify their beverage choice in a CSI.
Does anyone know if we can get TNEW to attach the performance (a GA concessions house) in their order to the CSI saved in their account? The CSI Activity Type requires a performance when added by an operator, but the web doesn't save one. The goal is to be able to pull a list of all CSI's related to that "performance" (which would be a list of drink orders for that night).
Many Thanks!
I can't think of a front end way to do this, LTR_TNEW_CUSTOM_FORM_SAVE_DATA only gives you the option for select fields of a CSI. You (or whoever has access to the database) could create a custom stored procedure that creates a CSI and determine within that procedure which performance should be associated.
In LTR_TNEW_COSTOM_FORM_SAVE_DATA, look for fields "Procedure Name" and "Use Stored Proc". Use these fields to point to the custom procedure created.
Another (back-end) way to do this is the continue using the standard TNEW created CSI but automate a check for these CSI's and update it with the correct perf_no.
I've done something very similar to this and am happy to talk with you about it in greater detail if you'd like. Feel free to pm me.
Hope this helps
Hi Jennifer,
Currently TNEW does not attach a performance to the CSI created from the Auxiliary purchase path, however that has been submitted as an enhancement request to a future version of TNEW.
In the meantime, there are some work-arounds, as Steven mentioned. One other though I had was to create a field on your aux page for your patrons to indicate which performance they are attending. This could be a required text field, or drop down list and the result will be listed in your CSI.
I hope that is helpful.
Kindest regards,
Suzie