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

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

  • 1
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
If you can get the URL from the file attachment field then you could make a formula text field that takes HTML tags
"<img src=\"" & [URL] & "\" />"
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
The 150 in the formula below sets the height.  alternatively you can set the width.
Photo of Stephanie

Stephanie

  • 722 Points 500 badge 2x thumb

My formula looks like this: "<img src=\"" & "https://rostr.disney.com/ROSTRWS/rest/v1/photos/rostrid/"; & [Personnel Number] & "\" />"


I wasn't sure where to put the " height=\"150\">"

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
Try this syntax

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


140 is the field id with the uploaded image.
Photo of Stephanie

Stephanie

  • 722 Points 500 badge 2x thumb
It's not from an attachment field, it's from a company webpage
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
I suggest that you post this was a new question.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
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

  • 26,482 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

  • 26,482 Points 20k badge 2x thumb
tip of the spear.
(Edited)
Photo of Ryan

Ryan

  • 940 Points 500 badge 2x thumb
this was a big help. I got it on the form to show, but it did not show on report. do i need to have the If statement on this second formula or no (i did not add).
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
You do not have to do the IF statement, but if you have records without images, then you will want to suppress the image if the file is not loaded.  otherwise there will be an icon showing of a missing image.