How do I display a picture on a form or report with a specified height and/or width?

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered
  • (Edited)
I need to capture pictures from an iPhone and then display them on the form with a specific height and/or width. I have been able to capture the picture using a file attachment field. I have not been able to get the right syntax for displaying the resized picture.

Any help is appreciated.
Photo of Jeff Mickelsen

Jeff Mickelsen

  • 324 Points 250 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,296 Points 50k badge 2x thumb
Try appending a space and then

width='75' >

If you are able to post you current formula I can help more
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,882 Points 5k badge 2x thumb
Hi Jeff,

No worries. Here you go.

If([Your attachment field]=null,null,"<img src='"&URLRoot()&"/up/" & Dbid () & "/a/r" & [Record ID#] & "/e217/v0' height='16' width='20' />")
Replace 217 with your attachment field ID and adjust height and width as per your need.

Photo of Matthew Neil

Matthew Neil

  • 31,658 Points 20k badge 2x thumb
Keep in mind that if you want to keep proper aspect ratios on the images, pick only one dimension to control.  Choose either height or width, not both.

I personally like height because it makes reports more consistent.