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?
"<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?
