Help

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

Solved
Jump to Solution
1491 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter4572
4 - Data Explorer
4 - Data Explorer

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

2022-12-11 12.21.png

1 Solution

Accepted Solutions
Soly
7 - App Architect
7 - App Architect

Hi @Peter4572 !

To do this you need to :

  • Create a button field type :

button 0.JPG

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

button.JPG

 

  • 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 :

button 2.JPG

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

button 3.JPG

 

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 ! 👍

 

See Solution in Thread

2 Replies 2
Soly
7 - App Architect
7 - App Architect

Hi @Peter4572 !

To do this you need to :

  • Create a button field type :

button 0.JPG

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

button.JPG

 

  • 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 :

button 2.JPG

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

button 3.JPG

 

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 ! 👍

 

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