Possible to Create Multiple Links in One Formula Field?
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
------------------------------
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
------------------------------
