Forum Discussion

KarenHenke's avatar
KarenHenke
Qrew Cadet
5 years ago

Display a .jpg attachment as an image in a notification

Hello, I know this has been asked before (in 2018) but the suggestions offered don't seem to work for me. I have an image attachment field that I'd like to add to an email notification displayed as...
File attachments
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
The field type should be set to formula Rich text.
Make sure you check the box in the file attachment field 

"Allow access to this file attachment from a Quickbase link without signing in"

You can set either the Width or change the parameter to Height,  and it will properly scale.  But do not set both or it will get skewed and distorted.

Then it should work.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
KatherineOakey's avatar
KatherineOakey
Qrew Member
5 years ago
The field type of the Image field?

Which field needs to be RTF?

The notification message field is set to Message Format HTML.  I changed Interpret Custom Message as HTML to Yes and now I see the URL and a broken link icon.

I know the file is externally available as I can paste the URL into Chrome and the image displays.


Kathy Oakey
University of Arizona Cooperative Extension
Maricopa Master Gardener



  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    This field here needs to be formula Rich Text.


    var text FileType = Right(ToText([My file attachment field]),".");

    If(Contains("jpg, jpeg, png",$FileType),
    "<img src=" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e282/v0' width='75' >")

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