In a formula column, the APPLY_MASK() function allows you to hide or show the characters in a selected column.

Formula

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

Configurator

Result

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

Configurator

Result