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

2232 2
Showing results for 
Search instead for 
Did you mean: 
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 number. So in this example, clicking on the cell would take me to

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
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},''&{ID Number})

(The IF() statement simply keeps you from having partial URLs linking to

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.