Discussions

Back to discussions
Expand all | Collapse all

Can't display images because of hexadecimal Record ID

  • 1.  Can't display images because of hexadecimal Record ID

    Posted 08-29-2018 23:02
    I have a formula to display an image uploaded through QUickBase which looks like this:

    "<img src='" & URLRoot() & "up/" & Dbid() & "/g/r" & [Record ID#] & "/ek/va/" & [Picture]  & "' width='150'>"

    The formula is producing a URL with the Record ID in a normal decimal number as shown here:
    https://kp.quickbase.com/up/bnspvexd9/g/r472/ek/va/image%2037.JPG">https://kp.quickbase.com/up/bnspvexd9/g/r472/ek/va/image%2037.JPG">https://kp.quickbase.com/up/bnspvexd9/g/r472/ek/va/image%2037.JPG

    THe actual URL however has it in hexadecimal:
    https://kp.quickbase.com/up/bnspvexd9/g/rq2/ek/va/image%2037.JPG

    Notice it says rq2 instead of r472.

    My question is how can I work around this to have the image show from this formula?



  • 2.  RE: Can't display images because of hexadecimal Record ID

    Posted 08-31-2018 10:36
    See the API docs:

    https://help.quickbase.com/api-guide/index.html#filemanagement.html

    You can specify decimal values for the rid, fid and vid using this url pattern:

    https://target_domain.quickbase.com/up/DBID/a/rRID/eFID/vVID

    Note the "a" path in the above URL. You are using the "g" path in your URL which takes obe32 encoded (not hexadecimal) values for the rid, fid and vid.