Skip to main content

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.


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.

Reply


Terms & Conditions