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