Forum Discussion

JasonHartwig's avatar
JasonHartwig
Qrew Member
6 years ago

URL for File Attachment

We have a table that is setup to allow a file attachment (PDF) to the record created (no separate table for attachments in this case).  We would like to be able to directly link to the uploaded file somehow.  I have created a formula to do this, but the path being output is displaying an error when attempting to access it. 
The URL from the formula matches the file URL up until the Record ID, where the QB record ID is numeric, the URL to the file is showing an alpha-numeric value.
Anyone know what is generating the alpha numeric ID in this case?

------------------------------
Jason Hartwig
------------------------------
APIs and custom code
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    Can you post your current formula and also the resulting URL that you see?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JasonHartwig's avatar
      JasonHartwig
      Qrew Member
      6 years ago

      Sure Mark.



      ------------------------------
      Jason Hartwig
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        Maybe we should just try to answer your real question.  Are you trying to create a link to the file?

        "<a href='"& URLRoot() & "up/" &Dbid() & "/a/r" & [Record ID#] & "/e7/v0' target='_blank' >" & [File] & "</a>"

        Replace e7 with the exx  where xx is the field ID of the file attachment.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------