Skip to main content
Question

Creating a Custom Name for a URL Link


Hi All,
I've imported an excel spreadsheet in QB containing URL's with short descriptive names. I had to create a separate URL field in QB to import the URL full path. In excel, you can create a name for the hyperlink but in QB the only name you can create in each record is the actual file name. How can you create a more short descriptive name in record for the URL link? Thanks

------------------------------
Mark Johnson
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+14
You can use a formula rich text field with the following syntax (Thanks to Mark of Your QuickBase Coach for originally posting this on threads)

var text Words = [Field With Short Descriptive Name];

var text URL = [Field With URL Link];

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

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