Discussions

 View Only
  • 1.  Possible to Create Multiple Links in One Formula Field?

    Posted 09-03-2020 12:11
    Edited by Michael Tamoush 09-03-2020 12:23
    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
    ------------------------------


  • 2.  RE: Possible to Create Multiple Links in One Formula Field?

    Posted 09-03-2020 12:24
    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
    ------------------------------



  • 3.  RE: Possible to Create Multiple Links in One Formula Field?

    Posted 09-03-2020 13:19
    Thansk Ill try that! Is there a specific syntax if I want to use a line break as the separator?

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



  • 4.  RE: Possible to Create Multiple Links in One Formula Field?

    Posted 09-03-2020 13:21
    np

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

    List("<br>", $LinkOne, $LinkTwo)

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