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