Forum Discussion
- ChuckGrigsbyQrew CadetIf you can get the URL from the file attachment field then you could make a formula text field that takes HTML tags
"<img src=\"" & [URL] & "\" />- StephanieHarrisQrew Assistant Captaincan this be edited to adjust the size of the picture?
- QuickBaseCoachDQrew CaptainThe 150 in the formula below sets the height. alternatively you can set the width.
- StephanieHarrisQrew Assistant Captain
My formula looks like this: "<img src=\"" & "https://rostr.disney.com/ROSTRWS/rest/v1/photos/rostrid/"; & [Personnel Number] & "\" />"
I wasn't sure where to put the " height=\"150\">"
- QuickBaseCoachDQrew CaptainNo 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.- _anomDiebolt_Qrew EliteThat's pretty clever for not using script:
Contains("jpg,jpeg,png,gif", Right([File],".")), - _anomDiebolt_Qrew Elitetip of the spear.
- RyanRyan2Qrew Assistant Captainthis was a big help. I got it on the form to show, but it did not show on report. do i need to have the If statement on this second formula or no (i did not add).
- QuickBaseCoachDQrew CaptainYou do not have to do the IF statement, but if you have records without images, then you will want to suppress the image if the file is not loaded. otherwise there will be an icon showing of a missing image.