Discussions

Expand all | Collapse all

How to display a thumbnail image on a table report

  • 1.  How to display a thumbnail image on a table report

    Posted 11-11-2019 10:43
    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
    ------------------------------


  • 2.  RE: How to display a thumbnail image on a table report

    Posted 12-19-2019 14:20
    Hey Freddie,

    I have images that are rotating 90 degrees on mobile - that are not rotating on mobile...  any advice on how to design for this?  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
    ------------------------------



  • 3.  RE: How to display a thumbnail image on a table report

    Posted 19 days 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
    ------------------------------



  • 4.  RE: How to display a thumbnail image on a table report

    Posted 18 days 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
    ------------------------------