Forum Discussion

AaronZielinski's avatar
AaronZielinski
Qrew Cadet
9 years ago

Photo Not Displaying in Record (form)

I am uploading a single photo to a form (record) as a file attachment.  I have chosen to option to display the image (.jpg, .png) on the form, but it is not displaying.  It is showing the file name wh...
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
Create a new field, Formula-Text, and call it something like "Image"

Insert this formula with a few modifications:

If([Picture File]="","","<img height=\"80\" src=\"" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e41/v0\" />")

The changes you will need to make are the "e41", change that to the field id of your file attachment field...
"eXX"
I put a conditional If statement to make it blank if the file is empty, so change the field [Picture File] to your file attachment field.
You can also control the size/height of the image

Let us know if you get stuck.
  • AaronZielinski's avatar
    AaronZielinski
    Qrew Cadet
    9 years ago
    Thanks Matthew.  Based upon John's response, it appears that it's there but only displaying in "view" mode vice "edit" mode.  I'm hoping to see it regardless of mode since we mostly work in "edit" mode.
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    9 years ago
    This method is one field and works in edit, view and reports.  

    I'd recommend not sizing the image for height & width, as this could distort your original.

    Make sure the "Enable HTML" checkbox just above the formula entry box is checked to display the image.

    "<img height=\"80\" src=\"" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e41/v0\" />"