Get/Extract URL from hyperlink

[Peter4572]

Please see screenshot below. I have domain names in one field and want a clickable "click here" text in another field that hyperlinks to the domain name, how can I do this? Thank you

 

[Soly · Accepted solution]

Hi @Peter4572 !

To do this you need to :

• Create a button field type :

Here is a screenshot of the description of the button field type in Airtable Support :

• Change the label to Click Here add the following formula to concatenate the www and the name in the Domain Name of the website :

"www." &{Domain Name}

This should look like this :

You now have the hyperlinked field that direct you to the website!🙂

This is an interesting resource if you need to dig more into what you can do with this field type :

https://support.airtable.com/docs/button-field

I hope that I could help you get what you want with your table @Peter4572 ! 👍

[kuovonne]

Given the text in the screen shot, I think that the formula should be a little different. 

"https://" & {Domain Name}

Note that if you want a text based link instead of a button, you can use a rich-text field. If you don't want to manually type in the text link in a rich-text field, you could use a formula field that creates the markdown link, and then an automation that copies the formula result to the rich text field. (The proper trigger for the automation might be a bit tricky since you need to be sure that data entry is complete and that the trigger occurs after the automation is turned on.)

"[Click here](https://" & {Domain Name} & ")"

[aelmore]

With this great info I was able to create a button on my table that links to the proper URL - however, the button is not clickable when added to an extension page designer. Any tips for getting a clickable button added to the page designer so that it can be clicked once downloaded as a PDF? Thanks!