Skip to main content
Question

Display a .jpg attachment as an image in a notification

  • March 2, 2021
  • 0 replies
  • 187 views

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 an image (not as a link to the image or the file name).

Thank you in advance for any guidance,
~k


------------------------------
Karen Henke
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • March 2, 2021
You can try this as a Rich text formula field,

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' >")

Where 282 would be replaced with the field ID of the file attachment field.

Note that the user will need to have access to the images without logging in.  I suggest checking the box on the file attachment field to allow access without logging in.


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