Re: File Link -> URL with Path

Earl, 
Austin has the right approach. if you just want to create a link to a file that can be used on a child table, then the folual is

"https://team.quickbase.com/up/bdb5rjd6h/a/r" & [Record ID#] & "/e8/v0"

(there was an errant semicolon in Austin's post).

if you need a formula for a hyperlink so that the user sees a file name, then the formula would be

var text Words = totext([my file attachment field])

var text URL = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e7/v0" 

//where you replace the 7 with the field ID of the file attachment field

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

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