Forum Discussion

DavidSirrine's avatar
DavidSirrine
Qrew Trainee
7 years ago

How do I create a Formula-URL in a parent table to link to an attachment in specific child record?

I would like to create a field in a parent table that displays a hyperlink to a file attachment in the most recent child record.  I have already created a summary field that finds the Record ID# of th...
File attachments
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
The URL formula would be this

URLRoot() & "up/" & [_DBID_DOCUMENTS] & "/a/r" & [Focus Document Record ID#] & "/e11/v0"


the e11 means that the file attachment is in field ID11.
The [_DBID_DOCUMENTS] needs to be the table name from advanced properties where the file attachment is stored.

If you wanted a hyperlink to allow display the file name, then that is another question and a bit fancier answer, but regardless, get this working first.