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

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

Parents
  • 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.

Reply
  • 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.

Children
No Data