Pictures on Exact Forms
I actually have posted this a couple times, but every few months I try again in case someone has figured it out, or maybe someone new stumbles across this. Has anyone found a way to get pictures o...
Forum Discussion
I've not run into the image rotation issue you mention, but I can tell you how to add an image in EF+.
You're going to start with 4 fields
Now, as for re-sizing the image, that is done with the 2nd number in the formula for the [EF Image] - in this example, 80. This controls the Width and will re-size the image based on that value and will maintain the aspect ratio of the original image.
Now, with all that said, feel free to combine any of the formulas, if you're comfortable with that.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
You're going to start with 4 fields
- The actual File Attachment field - called [FA] for our purposes
- A Formula URL field that results in the URL for the FA - [FA URL]
- URLRoot() & "up/" & DBid() & "/a/r" & [Record ID#] & "/e16/v0" - where 16 would be replaced with the FID of the FA field
- A Formula Rich Text field that displays the image referenced by the URL - [FA Image]
- "<div><img src=\""&[FA URL] & "\"></div>"
- A Formula Rich Text field that creates the necessary EF+ code - [EF Image]
- "<div style='text-align: left'>~i:45:80~</div>" - Where 45 would be replaced with the FID of the FA Image field
Now, as for re-sizing the image, that is done with the 2nd number in the formula for the [EF Image] - in this example, 80. This controls the Width and will re-size the image based on that value and will maintain the aspect ratio of the original image.
Now, with all that said, feel free to combine any of the formulas, if you're comfortable with that.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- Blake,
I have attempted all of that. The problem is, that only re-sizes the viewed picture. Meaning, it will look smaller when on the pdf, but if it was 5 megs before, it will still be 5 megs.
My issue is that if I have 5 pictures on a pdf, it becomes a 25 meg pdf. I can 'shrink' the pictures using the above formulas and instead of 80, use say 1 (extreme example), and it will still be 25 meg. I can make the 80, 5000. Still 25 megs. It doesn't change the file size, only how big or small it visibly prints.
Have you had success with it shrinking the actual file size itself using the above method?
------------------------------
Mike Tamoush
------------------------------- Yeah, you're correct. Any formulas in Quick Base will only change the displayed size. To actually change the size of the image, you may need to use a service like Kraken.io or something similar. Fortunately, they have APIs for scaling as well as for orientation. I've not used the service, so I can't speak for their reliability or ease of integration, but it looks pretty straightforward.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------- Currently I use the Juiced Add on, but it's tough on my users to push a button for every single photo. Ill check out Kraken.
This also ties into something you tried to help me with but I don't think we ever managed to figure out, which was trying to make a field that can determine the most current file size. I have ways I could use that to sort of help, but alas, all this is eluding me.
------------------------------
Mike Tamoush
------------------------------
