Discussions

Expand all | Collapse all

URL for File Attachment

  • 1.  URL for File Attachment

    Posted 17 days ago
    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
    ------------------------------


  • 2.  RE: URL for File Attachment

    Posted 17 days 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
    ------------------------------



  • 3.  RE: URL for File Attachment

    Posted 17 days ago
    Edited by Jason Hartwig 17 days ago

    Sure Mark.



    ------------------------------
    Jason Hartwig
    ------------------------------



  • 4.  RE: URL for File Attachment

    Posted 17 days 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
    ------------------------------



  • 5.  RE: URL for File Attachment

    Posted 17 days ago
    That worked perfectly.  Thanks Mark!

    ------------------------------
    Jason Hartwig
    ------------------------------