Possible to Create Multiple Links in One Formula Field?

Question

I know how to use a formula field to create a link to a record. but is it possible to create one formula field with links to multiple records, separated by semi-colon (or any separator really)?

My use case is as follows:
Grandparent: Trip Summary
Parent: Employees
Child: Events

The catch - on the events table, you select an event from a summary table (that pulls in events from a number of tables). So that particular link doesn't take you to the actual event (navigates to the summary table). I worked around this using a Formula rich text to get a link to the actual record. So that works fine.

However, I would like to provide a link to all events on my grandparent table. Right now, I simply made a report link to the child table, but that is only marginally successful because it can show a lot of duplicates. I am trying to come up with the best solution to provide links to my events on the grandparent table.

------------------------------
Mike Tamoush
------------------------------

MarkShnierYou · Answer

Easy peasy, do you know how to make a hyperlink field? If so, list list them and separate them by a space or if you want more than 1 space, you can use
 

as a separator. That means a non break space.

so like

var text LinkOne = (hyperlink formula);
var text LinkTwo = (hyperlink formula);

List(" &nbsp", $LinkOne, $LinkTwo)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community