Forum Discussion

JordanMcCaskill's avatar
JordanMcCaskill
Qrew Member
3 years ago

Help with File Attachment URL

I have been looking up how to generate the file attachment URL for a while now and the formula that continues to pop up is this one:

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/eg/v0/" & [Image]

The problem that I have been having is that the [Record ID#] is always passing a number into the url such as:

/up/dbid/a/r12/eg/v0/image.jpg

The correct URL for the image (based on inspecting the HTML) appears to always contain a letter in that position and there is not a direct mapping to numbers as the letters are not sequential:

/up/dbid/g/rn/eg/v0/image.jpg

The value following the dbid is also different but that appears to be a separate issue atm. Any help I could get with creating this URL for the image would be helpful.

------------------------------
Jordan McCaskill
------------------------------

6 Replies

  • This syntax should work

    URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0

    Then replace the 99 with the field ID of the file attachment field.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JordanMcCaskill's avatar
      JordanMcCaskill
      Qrew Member
      I read that multiple times while looking it up and for some reason it didnt click that I am not getting the direct link to the image but for the field.

      thanks for the help.

      ------------------------------
      Jordan McCaskill
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        Are you looking to display a thumbnail?

        "<img src=" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0 width=200>"



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