Creating unique hyperlinks

If you don’t want to use a button field or an interface button, the only way to do that would be to use a long text field with rich text enabled.

With a rich text field, you can type in some words to display, but then you can highlight those words and set a URL to turn those words into a hyperlink.

Hope this helps!

- ScottWorld, Expert Airtable Consultant

​@ScottWorld Thanks for the response - we have 100s of rows, so looking for an automated way to do this. I want to pull in existing text from a different field and hyperlink it automatically. Is there a way to do that? I have an existing field where we hyperlinked the word “link” for every row, but that isn’t what we are looking for - we want each link to have a unique display with the specific title. Thanks!

FYI: support article for further context.

If you want to get your hyperlink updated automatically each time the referenced fields get updated you can use the following structure:

 

Formula:
 

"["&Text&"]("&URL&")"

Automation:

 

Feel free to grab a slot using this link if you need some additional help setting this up. I’d be happy to help!

Mike, Consultant @ Automatic Nation

​@big87688 

Sure, you could automate this with Airtable’s automations.

You would need to create a formula that results in proper markdown formatting.

Here’s an example of a formula that results in proper markdown formatting for Airtable’s URL:

"[Airtable](https://airtable.com)"

Alternatively, if you have the name “Airtable” in a text field called “Text Field” and the URL https://airtable.com in a URL field called “URL Field”, then your formula would look like this:

"[{Text Field}]({URL Field})"

Then, your automation would need to “copy and paste” that formula into your rich text field.

Automations don’t technically “copy and paste”, so you would need to trigger the automation based on that formula field being updated, and then you would update the record’s rich text field with the contents of the formula field.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Just seeing ​@Mike_AutomaticN’s response now!

Great minds think alike! :)

- ScottWorld, Best Airtable Consultant

Oh yes ​@ScottWorld!
In fact I’m seeing that I am not using the formula at all on my automation, but just recreating it. Both ways would work!!

Oh right, even better! :)

I guess if he wants to create a conditional formula that takes other factors into consideration when generating the markdown, a formula field would be the way to go.

Also, using the formula field methodology guarantees that the automation will always trigger whenever the formula field is updated.

Otherwise, your way is simpler!

- ScottWorld, Expert Airtable Consultant