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
DavidSirrine's avatar
DavidSirrine
Qrew Trainee
7 years ago
Thanks! I got it to work with this formula:

URLRoot() & "up/" & [_DBID_ZWZ_Dwg_Revisions] & "/a/r" & [Maximum Record ID#] & "/e13/v0"

You also accurately anticipated my next need: having the link display as the name of the file attachment rather than the actual link.  How do I do this?

Also, if the target field has no attachment, I'd like the result of the formula to be blank.