Help

Holtink Instagram link in formula

Topic Labels: Formulas
358 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

3 Replies 3

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

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.

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:
Screen Shot 2021-05-18 at 8.20.12 AM

(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)

Can I somehow use ENCODE_URL_COMPONENT for this?

Labels