Forum Discussion

FreddieSabbs's avatar
FreddieSabbs
Quickbase Staff
6 years ago

How to display a thumbnail image on a table report

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...
Tips and tricks
EriksonTsang's avatar
EriksonTsang
Qrew Cadet
5 years ago
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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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
------------------------------