Skip to main content
Question

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

  • July 28, 2017
  • 0 replies
  • 80 views
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!
      This topic has been closed for replies.

      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
      • Author
      • Registered
      • July 31, 2017
      Thanks so much!!!
      • RebeccaL
      • Author
      • Registered
      • July 31, 2017
      When I make the link into a button it shows text "v0" instead of the link text. How do I change that?
      Can you please post your current formula and also confirm that the field type is URL formula
      • RebeccaL
      • Author
      • Registered
      • July 31, 2017
      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
      I assume that your field ID is 9 for the field which has the attachment.  Try using 9 without the leading zero.
      • RebeccaL
      • Author
      • Registered
      • July 31, 2017
      That worked. Thanks so much for your help
      Terms & ConditionsAccessibility statement