Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
No problem.
The low tech way to show an image on a form is to use the checkbox on the field properties to show the image. But that does not work when used on a report.
To show an image on a report this works
If(Contains("jpg,jpeg,png,gif", Right([File],".")),
"<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e140/v0" & " height=\"150\">"
, "No Preview Available")
or just
"<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e140/v0" & " height=\"150\">"
This would be a formula text field type
The e140 in the above refers to field ID 140 being the field holding the file attachment.
Play with the 150 to get the size you like. you can also specify instead width=\"150\"
Note that if you have a huge report of images, it will take a long time to load the page.
The low tech way to show an image on a form is to use the checkbox on the field properties to show the image. But that does not work when used on a report.
To show an image on a report this works
If(Contains("jpg,jpeg,png,gif", Right([File],".")),
"<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e140/v0" & " height=\"150\">"
, "No Preview Available")
or just
"<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e140/v0" & " height=\"150\">"
This would be a formula text field type
The e140 in the above refers to field ID 140 being the field holding the file attachment.
Play with the 150 to get the size you like. you can also specify instead width=\"150\"
Note that if you have a huge report of images, it will take a long time to load the page.
- _anomDiebolt_8 years agoQrew EliteThat's pretty clever for not using script:
Contains("jpg,jpeg,png,gif", Right([File],".")), - _anomDiebolt_8 years agoQrew Elitetip of the spear.