How to display a thumbnail image on a table report

Question

One of my favorite tips learned at EMPOWER2020 was from a session Chris Hutchens delivered titled Building for Mobile.

He shared how to get a thumbnail image of a photo to display in a table report. While the session was geared towards mobile users, it's applicable to anyone that wants to show an image in a table report.

I created a quick video to show demonstrate that little gem: https://youtu.be/M7p71Yo770c

If you'd like to try this in one of your apps, simply watch the video and copy this code snippet to paste into a formula - rich text field:

If(Length([Photo])=0,"","<img width=\"150\" src=\""&URLRoot()&"up/"&Dbid()&"/a/r"&[Record ID#]&"/e31/v0\"/>")

Enjoy!

------------------------------
Freddie Sabbs
Senior Solutions Consultant
Quick Base
fsabbs@quickbase.com
Cambridge MA
------------------------------

kevino_boyle · Answer

Hey Freddie,I have images that are rotating 90 degrees on mobile - that are not rotating on mobile...&nbsp; any advice on how to design for this?&nbsp; I want users to navigate to the table and a default report...and I don't know if they are more likely to use mobile or desktop.------------------------------Kevin O'Boyle------------------------------

eriksontsang · Answer

I have my photo attachment in the child tables. One parent record have multiple child record (each child has a photo attachment file).
Is there a way to display a "concatenated" thumbnail from the child records onto the parent record? similar to having like a "combined text" via summary field.

thanks

Erikson Tsang

------------------------------
Erikson Tsang
------------------------------

markshnier__you · Answer

I have done this before but I don't have the code handy.

The technique is to get the thumbnail code on the child record. Have a mirror field that changes that field into a regular text field as that is the only field type which can be used in a combined text summary field.

Once you have that string floated up to the parent, hen convert it back to a Rich text field by formula.

You will also then want to use SearchAndReplace on that string to change the semi colon delimiters to a space.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

slmpacdevelopme · Answer

Hey Freddie,Question for you. How do I get the field to display the current version of the file? For example, I have some photos that have been replaced since their original upload, but the thumbnail field still shows the original file? Weird! Any ideas?-jc------------------------------SLMPAC Development------------------------------

davidlessin · Answer

SLMPAC Development, &nbsp; Having spent over two hours on this in the past (deleting, replacing files, testing, blahh.). The 5 second fix is to clear your browsers cache! &nbsp; I included a screenshot of the formula field I used to display the attached file in a report (in this case, a country's flag).  &nbsp;  &nbsp;           David Lessin        &nbsp;      Director  +1 312 909 2721&nbsp;mobile      &nbsp;                          Information Services Group is a leading global technology research and advisory firm.  Confidentiality note: The above email contains information that is confidential and/or privileged. The information is for the use of the individual or entity originally intended. If you are not  the intended recipient, please contact the sender and delete the material from any computer. Please be aware that any disclosure, copying, distribution or use of this information is prohibited. Please consider the environment before printing this email or attachment.  &nbsp;

Forum Discussion

How to display a thumbnail image on a table report