Discussions

 View Only
  • 1.  Help with File Attachment URL

    Posted 06-10-2021 16:08
    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
    ------------------------------


  • 2.  RE: Help with File Attachment URL

    Posted 06-10-2021 16:18
    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
    ------------------------------



  • 3.  RE: Help with File Attachment URL

    Posted 06-10-2021 16:26
    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
    ------------------------------



  • 4.  RE: Help with File Attachment URL

    Posted 06-10-2021 16:33
    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
    ------------------------------



  • 5.  RE: Help with File Attachment URL

    Posted 06-10-2021 16:36
    yeah, I have all that already. I just trimmed down my example to the part that was giving me issues.

    Thanks again for the help though.

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



  • 6.  RE: Help with File Attachment URL

    Posted 06-10-2021 16:47
    But is it all working for you now?

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



  • 7.  RE: Help with File Attachment URL

    Posted 06-10-2021 16:49
    yeah, everything is working and tested.

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