Forum Discussion

JackWoods's avatar
JackWoods
Qrew Trainee
5 years ago

Profile Picture on Record - Formula Error

Hey Quick Base,

i was using a youtube video called "How to add images for picture perfect reports & Forms in Quick Base" by Quickbase Junkie. at around the 7:30 minute mark she starts talking about uploading profile photos.

https://www.youtube.com/watch?v=Ji2dMPNeyPg

I've created the two fields - one for Attachments - Field ID 51 - and one for the Formula to display the image. When I use the formula she describes I get an error. below is the formula I try to use. The error is on the "up/" section.


var text URL = URLroot() "up/" &DBid() & "/a/r" & [Record ID#] & "/e51/v0";

"<img src='" & $URL & "' width='48'>"

Please help :)

------------------------------
Jack Woods
------------------------------
File attachments
Formulas and functions
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    Well, if your images are all similarly sized and you don't need to resize them, you can always go into the properties of the field and select the option to show JPG/PNG/GIF images directly on forms here:

    If you DO need to resize them, you'll want to add an '&' in between the URLRoot and "up/", like this:

    "<img src = " & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e51/v0' width='48'>"


    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • JackWoods's avatar
      JackWoods
      Qrew Trainee
      5 years ago
      Thank you - that solved the image formula. I'm just going to go with the checkbox "Show Image" option in this scenario.

      ------------------------------
      Jack Woods
      ------------------------------