script for masking secure data fields

[rcrowell]

I am creating a invoice system and on the internal side we keep credit card numbers (i.e. 4412-5647-9568-5423) while on the client copy we want to mask the back end of the credit card numbers (i.e. 4412-XXXX-XXXX-XXXX) for security reasons. Is there a way to write a script to automate the masking of the numbers?

Thanks,

Ryan

[RussBaker]

You can create a calc text field "Credit Card Number to Print" which would =

Case(

Invoice Type = "Customer",

Left(CreditCardNumber,4)&"-xxxx-xxxx-xxxx",

CreditCardNumber

)

[SteveB]

It might be overkill, but you can encrypt the CC number with a free plugin from www.protolight.com