Discussions

Expand all | Collapse all

URL link with field name for link text

  • 1.  URL link with field name for link text

    Posted 14 days ago
    I'm trying to essentially recreate the effect of having a relationship, and clicking the 'display as a link to the related record'. I'm trying to do that, without having the relationship. I have considered, just making a relationship, but was thinking to avoid extra relationships I don't really need.

    If I use a URL field, I can create the link, but is there a way I can customize the link text based off another field (instead of just a default text of 'click here' or something)?

    Alternatively, if I could hyperlink a text field, that would work, but I dont believe that is an option.

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


  • 2.  RE: URL link with field name for link text

    Posted 14 days ago
    Are you saying that you know how to build the URL, but you want to know how to format it to look like a hyperlink?

    The generic form of a hyperlink is

    var text Words = ... some words or a field here;
    var text URL = .. some URL here;

    "<a href=" & $URL & ">" & $Words & "</a>"

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



  • 3.  RE: URL link with field name for link text

    Posted 14 days ago
    Perfect thanks! I actually used that long ago and forgot it was in my list of hints and tips.

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