Formula to create a URL across column cells, given the cell value

[Alexandra_Durbi]

Apologies if the title (or this description) isn’t clear!

Here’s an example of what I’m trying to do:

I have one column where every cell contains an ID number (eg. 837264). I would like to be able to click that number, and have it take me to the appropriate URL, where the URL is always of the from https://website.com/ID number. So in this example, clicking on the cell would take me to https://website.com/837264.

Is there a way to do this? I’m having trouble figuring out how to write a formula such that the URL base is the same across one column, and the unique cell value defines the end of the URL.

[Ali_Aboutera]

Alexandra_Durbin:

You probably cant do it in the same cell but you can do it with a formula, ive made an example for you

Airtable

Airtable: Organize anything you can imagine

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

[W_Vann_Hall]

@Ali_Aboutera is correct: You’ll have to assemble the URL in a second field.

Define a formula field called, oh, {Clickable URL}. Configure its formula to be

IF({ID Number},'https://website.com/'&{ID Number})

(The IF() statement simply keeps you from having partial URLs linking to https://website.com/.)

Expose {Clickable URL} in your view, or place it in a Page Designer Block, and selecting it should take you to the correct location. If you wish, hide {ID Number} to avoid confusion and save screen space.