Getting Started

 View Only
  • 1.  Profile Picture on Record - Formula Error

    Posted 10-26-2020 11:42
      |   view attached
    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
    ------------------------------


  • 2.  RE: Profile Picture on Record - Formula Error

    Posted 10-26-2020 12:39
    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/
    ------------------------------



  • 3.  RE: Profile Picture on Record - Formula Error

    Posted 10-26-2020 15:09
    Thank you - that solved the image formula. I'm just going to go with the checkbox "Show Image" option in this scenario.

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