Help

How to show email as ex****@gmail.com? in embade page only

1342 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Sunirmol_Apu
4 - Data Explorer
4 - Data Explorer

Hello i want to embed my tabil data now how can i show email as exam***@gmail.com! ??

4 Replies 4

Welcome to the Airtable community!

Try this formula. If the email address has less than 4 characters before the @, it will just show the email address without obscuring any characters.

IF(
    AND(
        {email},
        REGEX_MATCH({email}, ".+@.+"),
        LEN(REGEX_EXTRACT({email}, "^[^@]+")) > 4
    ),
    CONCATENATE(
        LEFT({email}, 4),
        REPT("*", LEN(REGEX_EXTRACT({email}, "^[^@]+")) - 4),
        REGEX_EXTRACT({email}, "@.+")
    ),
    {email}
)

Where i have to put this formula?

Create a new formula field and use the formula. Replace {email} with the name of your email field.

Here’s an alternate approach. Instead of building the obscured version based on the original’s length, you can automatically obscure all characters after the first one (or first few, depending on your preference) with a series of asterisks:

IF(Email, REGEX_REPLACE(Email, "(.{0,1})(.*)(@.*)", "$1***$3"))

Screen Shot 2021-07-06 at 7.53.05 AM

To leave more characters visible, change the second number in {0,1} to something higher.