Concealed ( MyText )
Display concealed text with a calculation. Concealed text displays dots instead of data to conceal confidential information - like a password or other highly sensitive data.
Be the first to rate this function Log in to vote
Lazarus Sismanis - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
FileMaker Pro 15 introduced concealed edit box.
However, one cannot display concealed text when the text is the result of a calculation.
With Filemaker 20.2.1 and the introduction of the layout calculation, one can display a text object
that features text as a result of a calculation.
Use this simple custom function when you need to display a confirmation that the calculation returns valid text without displaying the text itself. Or use to display partial text details, i.e. the last 4 digits of a credit card or ID number:
Left ( Concealed ( "1234-56-7890" ) ; 8 ) & Right ( "1234-56-7890" ; 4 ) = ••••••••7890
To add more language related characters or other symbols, just modify any of the multiple substitutions in the custom function.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.