In a column of type formula, the function APPLY_MASK () makes it possible to hide or to reveal the characters of a chosen column.
APPLY_MASK (column to hide, @@@ xxxx @@ x @)
To show, use: @
To hide, use: X
Example 1 (fixed number of characters)
In this example, for reasons of confidentiality, I want to hide my ID card number from my clients.
See article: How to hide columns from members of the notebook.
APPLY_MASK (CNI Number, XXXXXXXX @@@@)
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 9 characters are represented by X.
Example 2 (only show the beginning)
It is possible to display only the first characters desired.
For this, you must enter as many arobase (@) as characters.
APPLY_MASK (Postal code, @@)