How do I get an Image (file attachment field) to appear on the list report of main table page?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
How do I get an Image, which is currently a field in a form as a "file attachment", to appear as a much smaller version on a list report pertaining to that table?
Photo of Priscila Cavalcante

Priscila Cavalcante

  • 192 Points 100 badge 2x thumb
  • frustrated

Posted 2 years ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

You can use this code to capture the URL of the object in the file attachment field::

Below is a URL field. Call it [Company Logo URL]

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e6/v0/" & [Image]

[image] is the file attachment field.

===

Then....

Create a formula text field. Call it [Company Logo]

"<img src='" &[Company Logo URL]& "' width='148px' alt='"&[text field with text]&"' title='"&[text field with text]&"'>"

Put [Company Logo] in your report.



(Edited)
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

Pricilla,

I should have pointed out that the "6" in the code for [Company Logo URL] is the Field ID of the [Image] file attachment field. You'd probably need to edit that accordingly for your needs. Sorry about that oversight.

Photo of Priscila Cavalcante

Priscila Cavalcante

  • 192 Points 100 badge 2x thumb
Thanks Chris... if I do it this way, will the image in the [Company Logo] automatically be updates if new images are added? 
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
Yes, it will capture the latest update.
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Or you can just go straight to the formula text field for the image, and use something like this:

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

changing the "41" to the field ID of your file attachment field.
Photo of Priscila Cavalcante

Priscila Cavalcante

  • 192 Points 100 badge 2x thumb
Hi Matthew, this worked out perfectly. However, if I update the [image] field the new field which we called [display image] does not update with the current image. Is there something that can be done automatically or manually every time a new image is uploaded so that it can be reflected in the main table page? 
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
So QuickBase and Browsers seem to have a caching issue when files are updated.

If you upload a new file and you are testing it in your same browser session, you will want to clear your cache / history.  Then re-view the image.

odd I know...
Photo of Priscila Cavalcante

Priscila Cavalcante

  • 192 Points 100 badge 2x thumb
Wow, that is super easy...thank you! :-) 
Also, you can turn off the keeping of revisions in the file attachment field. That will usually prevent this issue as well.
Photo of Priscila Cavalcante

Priscila Cavalcante

  • 192 Points 100 badge 2x thumb
I will try this too.