Can a file attachment image thumbnail appear in a report?

This formula will put up a thumbnail.
//"https://www.quickbase.com/up/" & Dbid () & "/a/r" & //[Record ID#] & "/e6/v0\"height=\"1000\" width=\"1250\" target=_blank/> " &
"<img src = https://gesco.quickbase.com/up/" & Dbid () & "/a/r" & [Record ID#] & "/e6/v0\" height=\"300\" width=\"375\" target=_blank />"

note that e6 is the field ID # so change the 6 to whatever your file attachment field ID# is. eg e11 would be for fid 11.
adjust the height and the width of the thumbnail.

If you uncomment out the first two lines you would be able to click it to see a larger thumbnail, but it in neither case does it know how to scale the picture, so probably for full size undistorted viewing it would be best for your users to click on the file attachment file name if they want to see the thumbnail full size.

Don't be adding this thumbnail to large reports and certainly not to the List All report as it takes forever to load when there are hundreds of records.

Hi Mark,
Thank you for this response!  I may be doing someting wrong.  I used the following from your formula:

�<img src = https://tamarataylor.quickbase.com/up/"; &
Dbid () & "/a/r" & [Record ID#] & "/e8/v0\" height=\"300\" width=\"375\" target=_blank />

I used the new interface.
I put this formula in a report (that has 14 rows).
I created a calculated column in the report; with a field type of URL.

The system is saying there is a syntax error of:  
     Formula syntax error
     A formula must be a valid expression.
           �<img src = https://tamarataylor.quickbase.com/up/"; &
           Dbid () & "/a/r" & [Record ID#] & "/e8/v0/" & height=/"300/" & width=/"375/" & target=_blank />

Try adding a closing " quote.   I missed that in my copy and paste.

It's still failing.

Formula syntax error
There are extra characters beyond the end of the formula.
"<img src = https://tamarataylor.quickbase.com/up/";  ; &
 Dbid () & "/a/r" & [Record ID#] & "/e8/v0\" height=\"300\" width=\"375\" target=_blank />"

"<img src=\"https://gesco.quickbase.com/up/"; & Dbid () & "/a/r" &
[Record ID#] & "/e6/v0\" height=\"300\" width=\"375\" target=_blank />"

The above is what is working for me. In your post above, I am seeing some semi colons just after the "up/"   Are they really there?  If so, they don't belong there.

Hi Mark,
I copied and pasted again - to make sure i didn't miss anything - and I am no longer receiving the error (hurdle 1 - accomplished).  :)
Pasted formula is:

//"https://www.quickbase.com/up/"; & Dbid () & "/a/r" &
//[Record ID#] & "/e8/v0\"height=\"1000\" width=\"1250\" target=_blank/> " &
"<img src = https://tamarataylor.quickbase.com/up/"; &
Dbid () & "/a/r" & [Record ID#] & "/e8/v0\" height=\"300\" width=\"375\" target=_blank />"

However, the image doesn't appear in the report.  The report shows a url instead.  When clicked, it takes me to the following url that doesn't resolve.  Example:

http://%3cimg%20src%20=%20https//tamarataylor.quickbase.com/up/bhtkhxhbj/a/r1/e8/v0%22%20height=%22300%22%20width=%22375%22%20target=_blank%20/%3E

It seems to be adding extraneous info in the beginning (http://%3cimg%20src%20=%20) and spacers in the end, Is there something additional I need to do?

Click the checkbox on the field properties to enable HTML. :)

:)  I was trying to do it as a calculated column in the report - and not an actual field.  

I will work to add it as a field. :)  thanks for all of your assistance :)

It works! thx.

Is it possible to do the same thing only for a video file instead?  Is there an html tag for embedding video?