Help

Hyperlink ID replacement with column information?

Topic Labels: Formulas
778 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kristin_Turner1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone! 

Excel offers this ability so I'm wondering if there's a similar formula I can use to achieve this here?

Kristin_Turner1_1-1688731478835.png

 

I want the "Link" column to be populated with a URL but the ID at the end of the URL needs to be populated with the "Number" column.

Bonus points if you can show me how to hide the URL string behind the same name of the number column as well.

2 Replies 2
justjai
4 - Data Explorer
4 - Data Explorer

You do not need the =hyperlink for this formula as you would Excel, for Airtable you would use Encode URL Component

It would be: 

"https://example.com/manufacturing/workorder=" & ENCODE_URL_COMPONENT(Number)

 

> Bonus points if you can show me how to hide the URL string behind the same name of the number column as well.

Hmm, for this you'd need a long text field with rich text formatting enabled, and so you'd need an automation to grab the value from the formula field and paste it into the rich text field

How will this link be used?  If it's going to be in an email then can just use markdown for it, or if you expect users to have to click on it to open the link you could use a button field instead perhaps?