Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

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 ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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
------------------------------
  • MichaelTamoush's avatar
    MichaelTamoush
    Qrew Captain
    5 years ago
    Thansk Ill try that! Is there a specific syntax if I want to use a line break as the separator?

    ------------------------------
    Mike Tamoush
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      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
      ------------------------------