Forum Discussion

RebeccaL's avatar
RebeccaL
Qrew Cadet
8 years ago

How do I add a file attachment link to a report?

I have a relationship of one project to many documents and I want to have the link to the most recent document (file attachment) in a report of projects. Right now I am only able to add a link to the ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
No problem

Make summary field of the Maximum Record ID# of the documents. [Record ID# of most recent document]

Then make a URL formula field

URLRoot() & "up/" & [_DBID_DOCUMENTS] & "/a/r" & [Record ID# of most recent document] & "/e30/v0"

Adjust the table name to your own table name

Adjust the e30 to eXX where XX is the field ID if the file Attachment field.