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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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!
Photo of Rebecca L

Rebecca L

  • 352 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
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.
Photo of Rebecca L

Rebecca L

  • 352 Points 250 badge 2x thumb
Thanks so much!!!
Photo of Rebecca L

Rebecca L

  • 352 Points 250 badge 2x thumb
When I make the link into a button it shows text "v0" instead of the link text. How do I change that?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
Can you please post your current formula and also confirm that the field type is URL formula
Photo of Rebecca L

Rebecca L

  • 352 Points 250 badge 2x thumb
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"
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
I assume that your field ID is 9 for the field which has the attachment.  Try using 9 without the leading zero.
Photo of Rebecca L

Rebecca L

  • 352 Points 250 badge 2x thumb
That worked. Thanks so much for your help