Skip to main content
Question

Can't display images because of hexadecimal Record ID

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

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?

    This topic has been closed for replies.

    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.
    Terms & ConditionsAccessibility statement