Can a file attachment image thumbnail appear in a report?
It would be nice if there is an option to display a thumbnail version of image file attachments. Is this possible?
Forum Discussion
yes, it look like my posted answer was missing the <a href part at the beginning.
Here is one that works. I see that when I pasted it in, this forum lost some of my formula. Note that you will need to remove the extra spaces in the h r e f and the and w w w
If you don't want a new window, then you leave out the target = blank.
"<a h r e f=\"h t t ps://mycompany.quickbase.com/up/" & Dbid () & "/a/r" &
[Record ID#] & "/e6/v0\"height=\"1000\" width=\"1250\" target=_blank/> " &
"<img src=\"h t t p s://mycompany.quickbase.com/up/" & Dbid () & "/a/r" &
[Record ID#] & "/e6/v0\" height=\"300\" width=\"375\" target=_blank />"
Also since I made that formula I now realize that you should just specify a width or a height (but not both), and it will automatically scale the missing one. If you specify both, then it forces an aspect ratio distort the original photo.
Here is one that works. I see that when I pasted it in, this forum lost some of my formula. Note that you will need to remove the extra spaces in the h r e f and the and w w w
If you don't want a new window, then you leave out the target = blank.
"<a h r e f=\"h t t ps://mycompany.quickbase.com/up/" & Dbid () & "/a/r" &
[Record ID#] & "/e6/v0\"height=\"1000\" width=\"1250\" target=_blank/> " &
"<img src=\"h t t p s://mycompany.quickbase.com/up/" & Dbid () & "/a/r" &
[Record ID#] & "/e6/v0\" height=\"300\" width=\"375\" target=_blank />"
Also since I made that formula I now realize that you should just specify a width or a height (but not both), and it will automatically scale the missing one. If you specify both, then it forces an aspect ratio distort the original photo.
- Hi ,
I use your formulas for creating a field,thank you very much , It shows well in a report, but when I click on the image, the current firefox tab goes from report display to the current record display , and then it opens another tab where it shows the picture.
What I don't like is the current tab behaviour . I don't want to see the view of the current record, I want to stay on the report page.
Do you know how I can accomplish this ?
Thanks,
Mihai - The solution is to change the report to not allow to view the record. (uncheck the view box).
But then you ask "but how do they view thew record?"
Make a view button as a URL formula and make it be the first column on the report. Label the button is just V to keep it short.
urlroot() & "db/" & dbid() & "?a=dr&rid=" & [record ID#] - Thanks, it worked
best regards,
Mihai - Yep, been there, done it, bought the T shirt :). I was bit by that same problem.
