Skip to main content
Question

How to display clickable links from two separate tables under one field

  • April 23, 2025
  • 0 replies
  • 92 views
MeaganMcOlin
Forum|alt.badge.img+7

I have an app with the following setup. 

  • IVRT and ARHIFU are parent tables.
  • All Patients is the child table.

In All Patients, I have lookup fields pulling in patient name report link fields from both the IVRT and ARHIFU tables:

  • [IVRT Patient Name Link] (from IVRT)
  • [ARHIFU Patient Name Link] (from ARHIFU)

These lookup fields correctly show the patient names as clickable links in the All Patients table.

Now, I would like to display the clickable links from both of these parent tables under one field in the All Patients table. (See attachment).

The problem I am running into is keeping them as clickable links. 

How can I display the clickable links from both parent tables under one field in All Patients?

If a formula is needed to achieve this, what would that formula look like?

Thank you!
Meagan

Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • April 23, 2025

Megan,

Make a Formula Rich Text field.  You can the build out simple or sophisticated set of links in that field.  You can use some HTML to build a table, colorize or otherwise surface the two links for your Users.    The Magic Buttons application from Kirk Trachy was full of great examples of how to do this.

A quick and dirty example is 

var text LinkOne = URL for getting to parent one;

var text LinkTwo = URL for getting to parent two;

$LinkOne   & "<br>" &

$LinkTwo

That will give you both links on two rows, in the same field.

 

 

Terms & ConditionsAccessibility statement