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
Decision Group
http://www.decisiongroup.net

Sample input:

Concealed ( "MyPassword##12@" )

Sample output:

•••••••••••••••

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/**
* =====================================
*	Concealed (  MyText )
*
* PURPOSE:
*	Return concealed text as a calculation result. Concealed text displays dots instead of data to conceal confidential information - 
*	like a password or other highly sensitive data.
* 
* RETURNS: 
*	(string) text
*
* PARAMETERS:
*	MyText = The text that you would like to show as concealed.
*
* EXAMPLE: 
* 	Conceal ( "MyPassword##12@" ) = •••••••••••••••
*
* DEPENDENCIES:
*	none
*
* NOTES:
*	FileMaker Pro 15 introduced the 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 concealed text. 
*	An example would be using it as 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 some 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.
*
*	
* HISTORY:
*	CREATED: 2023-10-05: by Lazarus Sismanis ( Decision Group [ decisiongroup.net ] )
* =====================================
*/

Substitute ( 

	Lower ( MyText ) ; 

		["a" ; "•" ] ; 
		["b" ; "•" ] ;
		["c" ; "•" ] ;
		["d" ; "•" ] ;
		["e" ; "•" ] ;
		["f" ; "•" ] ;
		["g" ; "•" ] ;
		["h" ; "•" ] ;
		["i" ; "•" ] ;
		["j" ; "•" ] ;
		["k" ; "•" ] ;
		["l" ; "•" ] ;
		["m" ; "•" ] ;
		["n" ; "•" ] ;
		["o" ; "•" ] ;
		["p" ; "•" ] ;
		["q" ; "•" ] ;
		["r" ; "•" ] ;
		["s" ; "•" ] ;
		["t" ; "•" ] ;
		["u" ; "•" ] ;
		["v" ; "•" ] ;
		["w" ; "•" ] ;
		["x" ; "•" ] ;
		["y" ; "•" ] ;
		["z" ; "•" ] ;
		["0" ; "•" ] ;
		["1" ; "•" ] ;
		["2" ; "•" ] ;
		["3" ; "•" ] ;
		["4" ; "•" ] ;
		["5" ; "•" ] ;
		["6" ; "•" ] ;
		["7" ; "•" ] ;
		["8" ; "•" ] ;
		["9" ; "•" ] ;
		[" " ; "•" ] ;
		["-" ; "•" ] ;
		["_" ; "•" ] ;
		["!" ; "•" ] ;
		["@" ; "•" ] ;
		["#" ; "•" ] ;
		["$" ; "•" ] ;
		["%" ; "•" ] ;
		["^" ; "•" ] ;
		["&" ; "•" ] ;
		["*" ; "•" ] ;
		["(" ; "•" ] ;
		[")" ; "•" ] ;
		["~" ; "•" ] ;
		["{" ; "•" ] ;
		["}" ; "•" ] ;
		["[" ; "•" ] ;
		["]" ; "•" ] ;
		["|" ; "•" ] ;
		["<" ; "•" ] ;
		[">" ; "•" ] ;
		["+" ; "•" ] ;
		["=" ; "•" ] 

 )

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.

Comments

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

Concealed ( MyText )

Comments

Support this website.

Support this website.