How to create a "click here" hyperlink from a field name

Question

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 Answer

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!&#128578; 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-fieldI hope that I could help you get what you want with your table @Peter4572 ! &#128077;

kuovonne · Answer

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} & ")"

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded