Hi there,
I am trying to create some conditional masking that will help with a little glitch of how the rows for the boxes in a theatre display in the ticket.
At the moment, our boxes have numbers as their rows which means that when we use the Seat Row data element next to the Seat Number data element we just get a number next to a number but are unable to identify which box it belongs to. Each number currently set up as a Row matches the number of the box so with a conditional mask like this: Case(val When '8' Then 'Box 8' Else val) we can add the word Box to better identify where the seats are.
This is all working great up until that point, however, we have a total of 12 boxes in the theatre and the lenght of the field is not long enough to allow me to write out every scenario e.g. Case(val When '8' Then 'Box 8' When '7' Then 'Box 7' When '6' Then 'Box 6'....etc etc.
Does anyone know of a way I can get around that and perhaps do an interval for the When section so, When 1 to 12 or similar, and then in the Then section if I could use the value of val as part of the data element like I have done in the Else statement? Or, any other insights or suggestions would be greatly appreciated!
Thank you,
Carolina
I am currently running into this issue. Were you able to find a work around?
Hello Carolina,
Have you considered using a User Defined Data Element? You could create one that returns a string to include the word "Box " + row number based on the section.
If you have a DBA, they can update LP_TICKET_ELEMENTS accordingly. However, this depends if you're already using User Defined Data Elements - there's a limit of 6 that can be created.
Happy to help if you need any - let me know at martin.keen@nida.edu.au.
Martin
Hi Joe,
We ended up using a User Defined Data Element for this and created a support ticket to help us through the more complicated bits
I hope this helps!
Thanks Martin. That is exactly what we ended up doing!