Skip to main content

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.

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}


))

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!

Reply


Terms & Conditions