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...
Forum Discussion
Create a new field, Formula-Text, and call it something like "Image"
Insert this formula with a few modifications:
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.
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.
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.