Help

Can I jump to another table by using single text with hyperlink?

1193 4
cancel
Showing results for 
Search instead for 
Did you mean: 
CYLai
4 - Data Explorer
4 - Data Explorer

I want to create multiple tables to manage my students’ curriculum. Can I create a single text field and made it as an individual hyperlink cell?
e.g. Creating three tables with Overall, Student A and student B. Also creating a single text field named “Student name” . When I click Student A’s name, it can jump to A’s table. Such like this.

Thanks in Advance

4 Replies 4

Hi @CYLai - you can’t have a hyperlink in the way you can in Excel, for example, with a friendly name:

HYPERLINK (link_location, [friendly_name])

But you can have a field with URL values in it:

Screenshot 2019-05-25 at 16.26.06.png

Every table in your base has a unique link, so if you copy the URL for a student table into your overall table, clicking on the link will take you to the Student table. Note though that the link is target = _blank, i.e. it opens a new tab in your browser, rather than changing the current tab to the URL you have clicked.

JB

Hi @JonathanBowen - That’s also OK for me, but I can not find the way to get each table’s link whether I use right click of my mouse or another key. How can I do?

Hi @CYLai - just use the URL in your browser address bar:

Screenshot 2019-05-26 at 15.53.08.png

They all start with “tbl” (presumably for “table”)

JB

Hello @JonathanBowen - Got it!!! Thanks for your instruction!!