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
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!
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!