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

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

  • 384 Points 250 badge 2x thumb

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,348 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

  • 6,024 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,698 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.