Example 1 (fixed number of characters)

In this example, for privacy reasons, I want to hide my clients’ national ID card numbers from my team members.

See also: how to hide a column from workspace members.

APPLY_MASK(ID number, "XXXX@@@@")

In my Mask column, only the last four characters are displayed. 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)

You can choose to display only the first characters you need.

To do this, enter as many at signs (@) as the number of visible characters.

APPLY_MASK(Postal code, "@@")

• If the mask contains only @, the text is trimmed to the mask length.

→ bureau / "@@" = bu

• If the mask does not contain only @, the result is “blank.”