APPLY_MASK ()

In a column of type formula, the function APPLY_MASK () makes it possible to hide or to reveal the characters of a chosen column.

Formula

APPLY_MASK (column to hide, @@@ xxxx @@ x @)

Operation

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, @@)