Showing photos based on field value

[robertbody]

I have searched for this here and on the internet, and still don't find the solution. I had this working in Microsoft Access for years, now i need it in Filemaker instead.

I want a picture to show [perhaps in a Container field?] based on a field in the record [combination of 2 fields: /dir_field/images/filename_field.jpg] and i want this done at the record's "onLoad" trigger, when the record gets shown.

(I don't want to store the picture, nor do i want to import it, there are 8,000 pictures to do that for, instead i want the picture association to be automatic.)

In MsAccess I had a "picture field" which was a blank field initially, but upon loading the record it would get populated with "/" + dir_field + "/images/" + filename_field + ".jpg" -- that kind of formula, and a box actually showing it would use Source=picture_field.value kind of assignment

This is an urgent need and from my experimenting with Container Field i don't see a way to do it, i added a Container Field to the table, but with "Insert : Picture" i get a picture loading outside of this Container field, and then i don't see a place for putting in the script.

Thank you... i will be monitoring this page constantly for replies because this is an urgent need, and i am at a stand-still at the moment.

[mweiss]

Rather than a Container field, your field should be a Calculation, with "Calculation result is..." set to "Container".

[aholtzapfel]

Also, look at the webviewer. (It can display most any file that a browser can and path can be based off a field. It does somewhat limit the ways that it can be displayed.) :twocents:

[robertbody]

Yes... i have made that progress now (of using the Calculation Field which has an out put of "Container" value)... but now i get the text rather than the picture showing

calcuation: "/robert/www/robertbody/"&Directory&"/images/"&Filename&".jpg"

field return value: Container

but how to make it display a picture?

or have another container field showing the result of the other field that's a calculation field?

I don't see the link from Show Picture to calculated value. The only Show Picture ability i saw is from the Menu, "Insert" and "Image"

Progress.... Progress...

I started using the WebViewer object with Table1::Picturename2 in the source, that makes it try to load the picture

now what remains is getting the syntax right, not starting with /directory_root/etc/filename.jpg but with a syntax it understands... how do i do that?

it is expecting http:// format, but i don't want to tie in apache into this, i just want it to use at the filesystem

also, is the calculation possible to be done within the WebViewer object itself, rather than using a lookup from the Calculation field?

Thanks.. .great progress.. .so close

Now it appears that both my Picturename2 field and WebViewer fields are trying to show a picture, but are showing text instead... i am using filemac:/Users/robert...../etc/filename.jpg syntax, with "filemac:" trying to identify the file on the local directory, that seems to be the right prefix to use, right?

[robertbody]

I have a Calculation field displaying a Container result, and then I need a Web Viewer box to show it... that works great, and seems to be simplest solution i found.

I find the Web Viewer box limiting though, I would like it to have more controls to the width and position, because i have 3 different types of pictures 1) Vertical-500px high and 200pixels wide, 2) Horizontal-500px high and 700px wide and 3) Panoramic-880px wide and 200px high.

I would like to 1) to effect the Opaqueness of the picture (transparency) and 2) be able to center the picture within in

and if that's not possible, then having code to show 1 of 3 Web Viewer boxes, depending if it's Vertical, Horizontal or Panoramic.... but for that I would have to use image dimensions in a script... i need to find a way to do that

[mweiss]

If you want to display the image, use "imagemac" rather than "filemac".

[paifu]

I resolved the same kind of problem with a calculation field and this command in my case :

"imagewin:/D:/Databases/Fishs/" & hypDistributionMap

Result on a container

You have to put imagemac: instead if you work on Mac

On your case it must be something like

"imagemac:/robert/www/robertbody/"&Directory & "/images/"&Filename&".jpg"

field return value: Container