Help

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

2697 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Alexandra_Durbi
4 - Data Explorer
4 - Data Explorer

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.

2 Replies 2
Ali_Aboutera
6 - Interface Innovator
6 - Interface Innovator

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

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