Holtink Instagram link in formula

[Lauren_Briskin]

Hi!

I have a followup question to Format Instagram URL filed and I apologize for the beginner question, but I’ve been fighting with this!

I am inputting Instagram links like this one:
https://www.instagram.com/mhfirstoak/

Once I’ve removed the https://www.instagram.com/, I’d like to add @ and then link the whole thing back to the original URL https://www.instagram.com/mhfirstoak/ so it looks like @mhfirstoak

Any help appreciated!

[pcbowers]

@Lauren_Briskin It seems like what you are requesting is a hyperlink field. You want certain text, when clicked, to take you to another link. Unfortunately, this is currently not possible with formulas, though you could use the API with a Long Text Field with Rich Formatting enabled. See this post:

Can hyperlinks be created within a field? Ask the community

No, but there are ways to achieve pretty hyperlinks using the Markdown via the API, or manually creating them in the rich-text field. [image]

Another solution is to use the Button field, which allows you to create a button to a link generated by a formula. While it cannot have a dynamic name yet, you could put something a little more generic like Instagram Link or Instagram Profile. This way, it is still clear what the link is for and it is formatted nicely to click on within your base.

Airtable Support

Button field

The button field is an interactive field type that lets you trigger certain actions directly from your Airtable base. This article covers how to add the button field to your base and use all of the...

[Lauren_Briskin]

Oh interesting, thank you pcbowers!

So here’s the use case, and I actually have two different projects that have this same need. It sounds like all of my buttons would still look the same at first glance, so that’s not quite what I want, but maybe the use case will help- I’ve never used buttons!

I have a grid view that contains a list of IG links that looks like this:

(Image description: column of instagram links that cut off after first letter or two of https://instagram.com/…)

At a quick glance, this column is useless. I can of course expand the column, but it pushes the rest of the table out of view.

The useful part of the IG handle is the portion after https://www.instagram.com/ so ideally my list would look like

@ handle1
@ handle2
@ handle3

But that list is also fairly useless unless the handles are clickable.

So my original thought was to have the formula that generates the @ handle1 and then hotlinks it so it’s @ handle1

Is there a good workaround for this if I can’t do this in a formula field?

Thanks!!

(ignore the spaces in the @ handles- forum thinks i’m trying to @ people)

[Lauren_Briskin]

Can I somehow use ENCODE_URL_COMPONENT for this?