Hi all,
We don't really make use of masking here at the NT, so I'm hoping the network can provide some assistance with a query I have.
We want to use the data field Gift Certificate - GC Used In Order on some of our gift/credit voucher ticket designs as we use these a receipt when someone pays with a gift certificate, so that they can see their updated credit balance, but we don't want it to show a negative value as we're finding that when the gift certificate/credit voucher is created the amount shows here as a negative balance.
Is there any masking that I can place on the data field so that if the value is negative that nothing is shown?
Many thanks,
Geoff
For example, would something like If(val = '-', '', upper(val)) work as it does for hiding countries from address fields?
Hi Geoff,
Not sure if you can use like in conditional formatting but you could try
if(val like '%-%', '', val)
which will suppress any string which contains a - symbol.
Failing that, you might want to try one of the user-defined fields as Chris has suggested.
Grae
Thanks both, I've tried the code Graeme suggested and it is working, but now the amounts are printing far to the right on the ticket design. Any ideas why that might be? Is something in the mask acting as a space?
Good to hear it's (sort of) working. Not sure what's causing the weird justification, though. I assume you've set justify on the ticket element to 'Left'?
Hmmm, it seems we have a puzzler here, as all elements are justified left and there's nothing set to slide. I'll take another look at the other data elements on the design and make sure there's nothing odd about this particular one.
It wouldn’t, I don’t think: the entire value would have to be ‘-‘ for that to work. So a value of ‘-1.50’ wouldn’t trigger the mask.
Hmmm. I’m wracking my brains as to a way around this – but honestly, it might be best to use a user-defined data field if you have one spare. I think Mark Ridley could write you something that might work. If I have any brainwaves, I’ll let you know!
C.//
X.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Geoff White Sent: 11 March 2015 12:41 To: Chris Campbell Subject: Re: [Tessitura Ticketing Forum] Ticket design: conditional masking to hide negative values.
From: Geoff White <bounce-geoffwhite8962@tessituranetwork.com> Sent: 3/11/2015 8:23:46 AM
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!
Would something like this work?
If(val <0, ABS(val))
Susan
On 11 Mar 2015, at 15:36, Graeme Ellis <bounce-graemeellis3413@tessituranetwork.com> wrote: Hi Geoff, Good to hear it's (sort of) working. Not sure what's causing the weird justification, though. I assume you've set justify on the ticket element to 'Left'? Grae From: Geoff White <bounce-geoffwhite8962@tessituranetwork.com> Sent: 3/11/2015 11:06:06 AM Thanks both, I've tried the code Graeme suggested and it is working, but now the amounts are printing far to the right on the ticket design. Any ideas why that might be? Is something in the mask acting as a space? 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!
From: Geoff White <bounce-geoffwhite8962@tessituranetwork.com> Sent: 3/11/2015 11:06:06 AM