np
I'm aware that during some Automations and Sync processes a Hyperlink can get garbled.
But as you have found, you can cleanly pass though a URL and separately a file name.
The format for a hyperlink is this generic format as a formula Rich Text field.
var text Words = [my field with the words];
var text URL = [my field with the URL];
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------