Can't display images because of hexadecimal Record ID

  • 0
  • 1
  • Question
  • Updated 12 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:

THe actual URL however has it in hexadecimal:

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


  • 70 Points

Posted 12 months ago

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

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
See the API docs:

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

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.