URL link with field name for link text

Question

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
------------------------------

markshnier__you · Answer

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
------------------------------

michaeltamoush · Answer

Perfect thanks! I actually used that long ago and forgot it was in my list of hints and tips.------------------------------Mike Tamoush------------------------------

Forum Discussion

URL link with field name for link text