We'd like to mask the AccountNumber on a list for EmployeeBankDetails. I tried creating a Password type field and having it's value equal to AccountNumber but it didn't display as masked.
You can simply the Derived Field logic considerably by using a loop:
ZZZHiddenAccountNumber is a DerivedField type is Text ZZZHiddenAccountNumber = "" while (ZZZHiddenAccountNumber size < AccountNumber size) ZZZHiddenAccountNumber += "X" return ZZZHiddenAccountNumber
Can I ask what the point of having the "masked value" in the list is if noone can see it?
Could you do something like create a derived field that returns the actual account number as Alpha and then a second derived field that you would pull into the list using a series of if statements to return a string of X's that matches the character count of the derived account number or however many characters you actually want to show?
Derived Fields <br />ZZZAccountNumber is a DerivedField type is Alpha size 30 return (AccountNumber)
if (ZZZAccountNumber size = 29) return ("XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX") elseZZZHiddenAccountNumber is a DerivedField type is Alpha size 30 if (ZZZAccountNumber size = 30) return ("XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX") else<br />
if (ZZZAccountNumber size = 28) return ("XXXXXXXXXXXXXXXXXXXXXXXXXXXXX") else return ("")Alternatively you might be able to return a series of X's + the last 4 characters of the derived account number field and pull that into the list.
On a form you can use hidden entry (and display only) to show a masked non-editable field.
Looking at the LPL guide there doesn't appear to be any equivalent masking option for lists.
Thank you. I don't know if it matters the length of the characters displayed.