Skip to main content

Hyperlink Formula

  • April 4, 2019
  • 3 replies
  • 28 views
A
Forum|alt.badge.img+17

I need to build this /dp/B079KHS5CY

This part B079KHS5CY comes from my “Data” column.

How can I combine this together to form a proper URL?

Thanks in Advance

    3 replies

    JonathanBowen
    Forum|alt.badge.img+18
    • JonathanBowen
    • Inspiring
    • 1110 replies
    • April 4, 2019

    Hi @Abraham_Bochner - this should work for you:

    The formula field is:

    CONCATENATE('https://www.example.com/dp/', Data)

    I’ve added the full domain too, so that this becomes a proper URL. Even though this is a formula field and not a URL field, the result is still a clickable link from within Airtable (note that without the full domain Airtable does not recognise the result as a URL and it isn’t clickable).

    JB

    A
    Forum|alt.badge.img+17
    • Abraham_Bochner
    • Author
    • Known Participant
    • 75 replies
    • April 4, 2019

    Thank you very very much

    M
    • Madeline_Mann
    • New Participant
    • 1 reply
    • April 15, 2022

    Hi @Abraham_Bochner - this should work for you:

    The formula field is:

    CONCATENATE('https://www.example.com/dp/', Data)

    I’ve added the full domain too, so that this becomes a proper URL. Even though this is a formula field and not a URL field, the result is still a clickable link from within Airtable (note that without the full domain Airtable does not recognise the result as a URL and it isn’t clickable).

    JB


    This has been very helpful! I noticed that this doesn’t work with an email address. Is there any way around this that you know of?

    Thanks!


    Terms & ConditionsAccessibility statement