Hi - I am trying to create a field with unique hyperlinks that can be used in an interface (we don’t want a button or field that has a static name for every record).
I want to use the {link to content} field for the URL, and the {content title} for the display.
I am having trouble figuring this out, but I am sure there is a way to do it.
I would appreciate any help.
Thanks!
Page 1 / 1
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.
@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!
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.
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.