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
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
------------------------------
KatherineOakey's avatar
KatherineOakey
Qrew Member
5 years ago
This is the problem I'm currently working on.

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

[My file attachment field]   I assume is the field in the table that has the actual image.  Currently, my desired logo image is in a child table of the table the notification is being used on.   I want to use the same logo image for every notification that is sent.



Using just the <img src=     &displays the URL - yes, I can go to a browser, paste the URL in and it displays.

I have the pixel sizing for the image and I want to resize it smaller.  If I specify only a width, will the height be calculated on the aspect of the image?

This is what I currently have and still a URL and not the image itself.

var text FileType = Right(ToText([Images:Image]),".");

If(Contains("jpg, jpeg, png",$FileType),
"<img src=" & URLRoot() & "up/" & Dbid() & "/a/r" & 24 & "/e6/v0' width='75' >")

& 24 is the Record Id of the actual image
e6 is the field ID for the Image field

------------------------------
Katherine Oakey
------------------------------
  • 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
        ------------------------------