Discussions

 View Only
  • 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 10-08-2020 02:18
    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 10-08-2020 06:36
    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
    ------------------------------



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

    Posted 05-24-2022 13:17
    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
    ------------------------------



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

    Posted 05-24-2022 13:25

    SLMPAC Development,

     

    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!

     

    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).

     

     

    David Lessin

     

    Director

    +1 312 909 2721 mobile

     

    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.

     






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

    Posted 05-24-2022 13:42
    There was a discussion post about a month ago that talked about this caching issue. There have been a few solves for this, using new code (as opposed to constantly deleting cache).

    I don't have time to search and post the link, but if you search you can probably find it, or maybe someone else has the codes.

    ------------------------------
    Mike Tamoush
    ------------------------------



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

    Posted 05-24-2022 13:44
    Actually, just found it. Check out this thread.

    https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=ae68319c-2247-40b5-9dfc-3ae7924e01ae&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804

    ------------------------------
    Mike Tamoush
    ------------------------------