Hi there,
I am doing some ticket design clean up and stumped on how to more forward with some masking. Currently we have the standard price type data element on our tickets. This works great for our members/ GA/ Full Price price types. However, we also have a handful of comp price types (Comp - Artist, Comp - Press, Comp - Education, etc.). Rather than the specific comp price type printing on the ticket, I'd like to mask any of the comp tickets to just say 'Comp'. I was able to successfully use the mask function and it works great. However, now the other standard ticket prices (Regular, members) are blank because they do not qualify for the masking criteria.Here's my mask string: Case(val When 'Comp - Artist' Then 'Comp' When 'Comp - BO' Then 'Comp' When 'Comp - Education' Then 'Comp' When 'Comp - Press' Then 'Comp' When 'Comp - Staff' Then 'Comp' Else ' ')
1. I understand I could include the Regular ticket price in the string, but there appears to be a character limit on the masking field. (And for the number of new price types we create, I don't want to have to remember to update another item).
2. Price Type Alias would not work for us because we use that function for our online path and it is different from what get printed on the ticket.
3. I have thought about creating another ticket design for comps and hard coding the copy COMP where the price type field would be, but worried about managing ANOTHER ticket design in addition to our countless headers/receipts and designs.
4. The price type category would work (Comp, Member, Single, Subscription), but I do not see that as a standard element ID. The work around may be using the user defined element. Perhaps I am using the masking function incorrectly or may be someone has a work around where the text would change to comp IF it meets the mask criteria and if not, just use the price type description as is. Thoughts/suggestions/ideas?Joe
You may just want to change the Else part from '' to val. As in, the case statement ends in "Else val)". Currently, your case statement is telling it to print no text if it doesn't find one of those price types. If you can, just make it print the price type if it is not listed in the When parts.
Case(val When 'Comp - Artist' Then 'Comp' When 'Comp - BO' Then 'Comp' When 'Comp - Education' Then 'Comp' When 'Comp - Press' Then 'Comp' When 'Comp - Staff' Then 'Comp' Else val)
This may or may not work, but it is probably worth an attempt.
Thanks Neil! That did the trick. Thanks for your help. I also updated the data from Price Type Description to Price Type Short to reduce the number of characters required in the parameter field and added discount masking too! I also was able to combine all the qualifying price types before stating the then so my final string is:Case(val When 'C-Artist' , 'C-BO' , 'C-Bloom' , 'C-Citi' , 'C-Devo', 'C-Paper' , 'C-Press' , 'C-Staff' , 'C-VIP' Then 'Comp' When 'DISC1', 'DISC2', 'DISC3' Then 'Discount' Else val)
Glad to hear that it helped you. I like the comma delimited qualifier in the when part.
Now, lets see if you remember to update the ticket design masking when you add a new Comp or Discount price type. Good luck with that.