Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 09, 2022 07:07 PM
Hello, I have a whole column of data with html links and I need these to be clickable links with the respective titles:
DATA:
<a href=https://www.coronavirus.tas.gov.au/media-releases/important-coronavirus-test-information>Tasmanian Government: Important coronavirus test information</a>
Needs to be
Tasmanian Government: Important coronavirus test information
How can I achieve this via airtable?
There are so many, relinking them all by hand is going to be tedious. Thanks
I will ultimately be exporting this to excel.
Dec 10, 2022 10:15 AM
You can extract the URL or title, but I don’t think you can’t embed a URL within the title like you did in your post, at least not in a URL field. Both URL and titles have to be in their respective fields. There are a few ways to do it, the easiest being a script, but if you want to just use formula fields, I think the MID function can help you:
[Mid] function lets you extract a certain number of characters starting at a specific place within a string. It follows this format: MID(string, whereToStart, count).
The variables are:
string: Your anchor tag
whereToStart: Right after the “=“ symbol
count: Distance between whereToStart and where the URL ends (right before the “>” symbol)
So, you will need to figure out the starting position and count (distance from start to end):
Putting it all together:
MID({Anchor Tag}, FIND("=", {Anchor Tag}) + 1, FIND(">", {Anchor Tag}) - (FIND("=", {Anchor Tag}) + 1))
Here’s a link to a base with everything put together. I’ll leave it up for a few days:
Zemanir Airtable Consulting: www.zemanir.com
Dec 12, 2022 06:01 AM
How would you be exporting this to Excel and what version of Excel are you using?
If you're exporting your Airtable data as a CSV I vaguely recall that there's a `=HYPERLINK()` formula for Excel, so you might want to format your Airtable data into that format first before the export
Feb 16, 2024 02:03 AM - edited Feb 16, 2024 02:06 AM
Feb 17, 2024 09:31 PM
You can't use a formula field for this I'm afraid. You'll need an automation that updates a long text field with rich text formatting turned on
You could also do this with JavaScript via the script extension or Run a Script automation action
Link to base
Feb 19, 2024 02:39 AM - edited Feb 19, 2024 03:09 AM
Thanks. I am sure that this would be very helpful but regretfully I can't see anyone's screenshots. They all appear as broken links.
Edit: cleared my cookies and now it works
Thanks
Feb 19, 2024 04:09 AM
This isn't so straight forward from Zapier. Please see:
Zapier process:
Airtable results:
I found the final solution here which turned out to be:
Zapier process:
Result: