Can i add a picture of a product to products table?

  • 1
  • 1
  • Question
  • Updated 11 months ago
  • Answered
I wanted to see if I could add a picture of each product to the products table and form. I know I can add an attachment, but I'm looking for the picture to remain up within table and form when i view it. Is there a way to do that?
Photo of Ryan

Ryan

  • 940 Points 500 badge 2x thumb

Posted 2 years ago

  • 1
  • 1
No problem.
The low tech way to show an image on a form is to use the checkbox on the field properties to show the image.  But that does not work when used on a report.

To show an image on a report this works

If(Contains("jpg,jpeg,png,gif", Right([File],".")),

"<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e140/v0" & " height=\"150\">"
, "No Preview Available")

or just

"<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e140/v0" & " height=\"150\">"


This would be a formula text field type

The e140 in the above refers to field ID 140 being the field holding the file attachment.

Play with the 150 to get the size you like. you can also specify instead width=\"150\"

Note that if you have a huge report of images, it will take a long time to load the page.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
That's pretty clever for not using script:

Contains("jpg,jpeg,png,gif", Right([File],".")),
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
tip of the spear.
(Edited)