Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

Link to file itself

I have a table of files (pdfs), and I am trying to create a link to the file itself. I can create a link to the record entry without issue, but is there a way to create a link where it launches to the pdf (file attachment field) itself?

EDit: Found this on another thread but cant get it to work. RIght now it says page unrecognizable.

URLRoot() & "up/" & "db/xxxxxxxxx?" & "/a/r" & "63" & "/e7/v0"

WHere 63 is record if and 7 is fid
------------------------------
Mike Tamoush
------------------------------
  • Try this format
    URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0"

    Replace 99 with your field ID which has the file attachment.

    The local PC settings will determine if the PDF will open or download.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      I edit my post right when you responded. I ended up getting it to work using this (what you suggested essentially):

      URLRoot() & "up/" & [_DBID_TABLENAME] & "/a/r" & "63" & "/e7/v0"

      Do you know why what I edited in my original post didnt work? I'm thinking maybe the '?' or something?

      ------------------------------
      Mike Tamoush
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        right, there is no ? question mark

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