Discussions

Expand all | Collapse all

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

  • 1.  How do I add a file attachment link to a report?

    Posted 07-27-2017 21:14
    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!


  • 2.  RE: How do I add a file attachment link to a report?

    Posted 07-27-2017 21:37
    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.


  • 3.  RE: How do I add a file attachment link to a report?

    Posted 07-31-2017 15:01
    Thanks so much!!!


  • 4.  RE: How do I add a file attachment link to a report?

    Posted 07-31-2017 15:07
    When I make the link into a button it shows text "v0" instead of the link text. How do I change that?


  • 5.  RE: How do I add a file attachment link to a report?

    Posted 07-31-2017 15:20
    Can you please post your current formula and also confirm that the field type is URL formula


  • 6.  RE: How do I add a file attachment link to a report?

    Posted 07-31-2017 15:27
    This is my formula and I confirmed the field type to be URL formula

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


  • 7.  RE: How do I add a file attachment link to a report?

    Posted 07-31-2017 15:37
    I assume that your field ID is 9 for the field which has the attachment.  Try using 9 without the leading zero.


  • 8.  RE: How do I add a file attachment link to a report?

    Posted 07-31-2017 15:46
    That worked. Thanks so much for your help