Swap Number within range with Text Value using Ticket Design Mask?

Nicholas

Try it without the quotes around the values. You’re dealing with money values and putting it in quotes treats it as text. Hopefully, that does the trick!

Case(val When 15.00 Then 'Memb1' When 20.00 Then 'Memb2' When 50.00 Then 'Memb3' When 80.00 'Memb4' Else '')

If it doesn’t I would add the field represented by val without a mask to the design – just to make sure it is returning 15.00, 20.00, 50.00 or 80.00.

Cheers

S.

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nicholas Hudson-Ellis
Sent: Friday, 27 December 2013 5:24 PM
To: Sandra Ashby
Subject: Re: [Tessitura Ticketing Forum] Swap Number within range with Text Value using Ticket Design Mask?

Here's a little progress report. After following a very useful tip from Kathleen Smith (Thanks!), I manually typed the mask text into Tess rather than pasting in from my text editor. This had the immediate effect of the mask running, except the 'Else' value is always returned. 

I've tried a few variations of the expected value I am testing with (15, 15.00, $15, $15.00), but the Else value is still returned.

Hello all,

In an effort to clean up some of our many ticket designs, I am trying to insert the name of a Membership product into a Ticket Design based on the Amount Paid, which can reliably be linked to the product.

My idea was to use the 'Payment-Amount-1' data field, and use this mask below to swap the dollar value with a description of the membership, but alas only the mask text is shown.

Case(val When '15.00' Then 'Memb1' When '20.00' Then 'Memb2' When '50.00' Then 'Memb3' When '80.00' 'Memb4' Else ' ')

Has anyone else worked with this? I suspect that data fields with number values do not play well with Masks, but am not sure. Better would be a way to have a If <= operator!

Thanks for reading.

Nicholas

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!