Brian Dunning's FileMaker Custom Functions

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   Lazarus Sismanis - Show more from this author
Decision Group

Share on Facebook Share on Twitter

  Sample input:
Concealed ( "MyPassword##12@" )
  Sample output:

  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.



Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 19 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: