In a formula column, the APPLY_MASK() function allows you to hide or show the characters in a selected column.
APPLY_MASK(colonne à masquer, @@@xxxx@@x@)
How it works
To display use : @
To hide use : X
Example 1 (fixed number of characters)
In this example, for confidentiality reasons, I want to hide the ID card numbers of my clients from my staff.
See article : how to hide a column from members
APPLY_MASK(Numéro CNI, XXXX@@@@)
In my Mask column, only the last 4 characters are displayed. Indeed, in my formula :
- The last 4 characters are each represented by @.
- The first 4 characters are represented by X.
Example 2 (display only the beginning)
It is possible to display only the first few characters.
To do this, enter as many arobases (@) as there are characters.
APPLY_MASK(Code postal, @@)