Ticket design: conditional masking to hide negative values.

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.

For example, would something like If(val = '-', '', upper(val)) work as it does for hiding countries from address fields?

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

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!

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.

For example, would something like If(val = '-', '', upper(val)) work as it does for hiding countries from address fields?

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

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!