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

Question

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 document report associated with the project. This requires me to click the report link, then click the file attachment that downloads and then click back to the report. I'd like to be able to download the file directly from the report.

Is this possible?

Thanks!

quickbasecoachd · Answer

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.

rebeccal · Answer

Thanks so much!!!

rebeccal · Answer

When I make the link into a button it shows text "v0" instead of the link text. How do I change that?

quickbasecoachd · Answer

Can you please post your current formula and also confirm that the field type is URL formula

rebeccal · Answer

This is my formula and I confirmed the field type to be URL formulaURLRoot() &amp; "up/" &amp; [_DBID_DOCUMENTS] &amp; "/a/r" &amp; [Record ID# of most recent document] &amp; "/e09/v0

Forum Discussion

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

Related Content

Attachment - file name

IF Statement based on a file being attached

File Name for PDF attachments

PDF Document Generator, automatically attached to a record

Notification with attachment