Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Jul 03, 2021 07:55 AM
Hello i want to embed my tabil data now how can i show email as exam***@gmail.com! ??
Jul 03, 2021 10:03 AM
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}
)
Jul 03, 2021 10:41 AM
Where i have to put this formula?
Jul 03, 2021 12:41 PM
Create a new formula field and use the formula. Replace {email}
with the name of your email field.
Jul 06, 2021 07:58 AM
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"))
To leave more characters visible, change the second number in {0,1}
to something higher.