@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.
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
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?
(ignore the spaces in the @ handles- forum thinks i’m trying to @ people)