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
You can do this with two formula fields:
First create a formula text field with with this formula:
"https://www.quickbase.com/up/"; & Dbid ()
& "/a/r"
& [Record ID#]
& "/e6/v0?"
& [employee image]
[employee image] is the file attachment field
Replace https://www.quickbase.com with your domain name.
The 6 in e6 is the fid of the file attachment field
Then to display the image - create a second field
This is also a formula text field with the allow some html box checked
"<img src=\""
&[image href]
& " height=\"75\""
& " width=\"75\""
& "\"/>"
Where [image ref] is the first formula field
Good luck
Neil
First create a formula text field with with this formula:
"https://www.quickbase.com/up/"; & Dbid ()
& "/a/r"
& [Record ID#]
& "/e6/v0?"
& [employee image]
[employee image] is the file attachment field
Replace https://www.quickbase.com with your domain name.
The 6 in e6 is the fid of the file attachment field
Then to display the image - create a second field
This is also a formula text field with the allow some html box checked
"<img src=\""
&[image href]
& " height=\"75\""
& " width=\"75\""
& "\"/>"
Where [image ref] is the first formula field
Good luck
Neil
- Thanks Neil. 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.
- I think our messages crossed. The method above works in both modes. I just tested it on our system.
Neil - I think I'm messing up somewhere. The first formula is showing up on the edit page and a generic thumbnail directly below it. A few questions:
1. Do I need to take out or leave in the spaces in the second formula (the ones going from line to line)?
2. The "6" in the second formula. Is that the # of the Form Element of the first text formula we created?
Here is a snapshot below that is showing up:
Thanks for you patience! - You want to display the second formula field - the first one is just a link to the file attachment field. The 6 is the field id of the file attachment field. On our system 6 is the field id of the field labeled [employee image].
If you paste your two formula fields in your response I'll check them for syntax.
Neil
