# Hyperlinks from related table

**URL:** <https://connect.superhuman.com/t/hyperlinks-from-related-table/33761>\
**Category:** Ask the Community\
**Created:** [September 12, 2022, 10:17pm UTC](https://connect.superhuman.com/t/hyperlinks-from-related-table/33761 "2022-09-12T22:17:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bruce\_F\_Donnelly](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/bruce_f_donnelly/32/9793_2.png) [@Bruce\_F\_Donnelly](https://connect.superhuman.com/u/Bruce_F_Donnelly)\
**Post date:** [September 12, 2022, 10:17pm UTC](https://connect.superhuman.com/t/hyperlinks-from-related-table/33761/1 "2022-09-12T22:17:40Z")

</div>

I have two tables, and the first pulls records from the second column using a lookup column. That column has “Allow multiple selections” selected in its Column options. There are thus two or more “pills” from the second table in a column in the first table.

So far so good, but I want to pull hyperlinks from the second table into the first one. It seems to be impossible, but is it impossible?

For context, the first table has sections from parts of a city code that refer to parts of a state code. Each section in the city code can refer to more than one entry in the state code, and vice-versa. I want to be able to print the table to a pdf in a report, so the reader can click through to both the state code and the city code without having to bother with Coda itself. Beyond that, the visual presentation isn’t that important. It can be a nested bulleted list. In fact I tried it that way, but I still couldn’t pull hyperlinks, only “@” links.

Thanks!

---

<div class="post-metadata">

**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\
**Post date:** [September 12, 2022, 10:29pm UTC](https://connect.superhuman.com/t/hyperlinks-from-related-table/33761/2 "2022-09-12T22:29:58Z")

</div>

Hi Bruce,

Could you share a doc showing more or less what you are trying to achieve?

What I understand from your posting should be quite easy to achieve, but I worry that I might have misunderstood you.

But try this :

https://coda.io/embed/NmJCR6fw97?viewMode=embed

As far as I am aware it is not possible to make the lookup column, i.e. the display column in the TV Station Links table a clickable link. But you can pull in a column with type URL, display that, and hide the display column.

Regards  
Rambling Pete

---

<div class="post-metadata">

**Author:** ![Bruce\_F\_Donnelly](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/bruce_f_donnelly/32/9793_2.png) [@Bruce\_F\_Donnelly](https://connect.superhuman.com/u/Bruce_F_Donnelly)\
**Post date:** [September 13, 2022, 4:42pm UTC](https://connect.superhuman.com/t/hyperlinks-from-related-table/33761/3 "2022-09-13T16:42:50Z")

</div>

Thanks! It worked.

I had tried what you suggested, but the problem was that the link format didn’t work with more than one record from the second table in a row in the first. It showed two globe icons, but without working links. It worked if I did a lookup (or, I assume filter) and then pulled in the records after the filter formula itself.

https://coda.io/embed/mmMwQG2nYE/_su1XC?viewMode=embedplay

---

<div class="post-metadata">

**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\
**Post date:** [September 13, 2022, 6:02pm UTC](https://connect.superhuman.com/t/hyperlinks-from-related-table/33761/4 "2022-09-13T18:02:28Z")

</div>

HI Bruce,

Thanks for letting me know. I have asked access to your doc, to see how you have done that. I have also added a method to my example doc that does not use the link column type, but uses text and then adds a hyperlink using Ctrl-K.

Regards  
Piet

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [December 12, 2022, 6:02pm UTC](https://connect.superhuman.com/t/hyperlinks-from-related-table/33761/5 "2022-12-12T18:02:40Z")

</div>

Closed on December 12, 2022, 6:02pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.