Skip to main content

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

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

Thank you very very much

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!

Reply


Terms & Conditions