Can't display images because of hexadecimal Record ID

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
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?

Photo of wilsonao

wilsonao

  • 70 Points

Posted 3 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,884 Points 20k badge 2x thumb
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.
(Edited)