Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Regex formula needed for URL http:// & https:// check and add if not there

Topic Labels: Formulas
Solved
Jump to Solution
1835 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Christen_Kruger
4 - Data Explorer
4 - Data Explorer

I am sending URL’s from Webflow which does not have URL validation easily integrated. I want to check and add the https:// to the beginning of the URL if it is not present when the field is created or updated.

I have been looking through to forums but can’t seem to find an exact match. Would love some help with this please.

2 Solutions

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

Here is one formula.

IF(
    FIND("https://", {url}),
    {url},
    "https://" & {url}
)

Here is a slightly fancier version:

IF(
    OR(
        FIND("https://", {url}) = 1,
        FIND("http://", {url}) = 1
    ),
    {url},
IF(
    {url},
    "https://" & {url}
))

See Solution in Thread

Hi @kuovonne - Amazing! This works perfectly. Thank you for your very prompt reply!

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

Here is one formula.

IF(
    FIND("https://", {url}),
    {url},
    "https://" & {url}
)

Here is a slightly fancier version:

IF(
    OR(
        FIND("https://", {url}) = 1,
        FIND("http://", {url}) = 1
    ),
    {url},
IF(
    {url},
    "https://" & {url}
))

Hi @kuovonne - Amazing! This works perfectly. Thank you for your very prompt reply!