Hyperlink ID replacement with column information?

[Kristin_Turner1]

Hi everyone! 

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

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.

[justjai]

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)

[TheTimeSavingCo]

> 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?