Can a file attachment image thumbnail appear in a report?

  • 2
  • 3
  • Question
  • Updated 9 months ago
  • Answered
It would be nice if there is an option to display a thumbnail version of image file attachments. Is this possible?
Photo of Gena

Gena

  • 30 Points

Posted 6 years ago

  • 2
  • 3
I'm trying to better understand your question.  Are you saying that you have a formula which works when you click the link, but the thumbnail is not working?
Photo of Josh Collins

Josh Collins

  • 422 Points 250 badge 2x thumb
Sorry if my question was unclear.  I have 2 different fields:

1) I have a basic URL field in App 1 where I manually add a URL for an image.  When I save then click that URL, the link works fine (in other words, a new tab opens and I see the image that I linked.)  The link I'm using happens to be out of a different Quick Base application where I store all the images I want to use, we'll call that "Images App."

2) I have a Formula Rich Text field in App 1 where I use the code you provided to display a thumbnail image.  The reference field in the formula (E35) is the URL field from #1 above.

I'm guessing that since the field in #1 above is referencing a URL, not a file attachment field, the formula in #2 field isn't pulling an image.

My question is: Is there a way to pull the image that the URL field is reference?  If not, then is the only solution to upload the image via a file attachment field in App 1 rather than my dedicated "Images App"?

Thanks!
You do not need to double load your images.  But you will need to replace the dbid() with the table "code" in the other app.  and you will need to replace Record ID with the record ID of the record that holds the image in the other app.

But before I go into the suggestion of the code, why not just make a relationship back to your images table and pull the image formula down as a lookup field?
Photo of Josh Collins

Josh Collins

  • 422 Points 250 badge 2x thumb
Re the relationship: I'm sure that will work.  I'm not super adept at relationships from other applications though.  I'll give it a shot and probably ask some questions in the process. ☺ 
The point is that you will need to specify the Record ID of the images app, in the formula, so it knows which image to pull, so may as well select that off a relationship.

This conversation is no longer open for comments or replies.