Container field = referenced JPG?

[kmoreau893]

I'm trying to do something very simple (I believe with FM Pro 7 on the Mac) and I think I need containers. I've inserted images into containers manually, but I'd like FM to do it 'on the fly'.

I have a directory of 'tif' files at the same level as the current filemaker pro database file. (I could easily convert these all the jpgs or PICTs if necessary)

The names of the files match a field called 'product_id' in the filemaker database, with a ".tif" or optionally ".jpg" at the end. Example a value in product_id might be "sample" and there is a corresponding image file called "sample.jpg" in the relative path path ../catalog/images/

I would like to simply have filemaker reference these files by using the value in the "product_id" field, concatenate it to "sample.jpg" or such, and show that picture. Something akin to relative links in web pages. Is something like this simple in FM?

Thanks for any advice.

-Keith

[-Queue-]

Use a calculation with a container result

"image:../catalog/images/" & product_id & ".jpg"

On Windows, it's image:../catalog/images..., so the Mac syntax may not be exactly correct. Someone else will have to verify that, though.

[transpower]

It can be done, but it takes several script steps. The Insert File step requires a fixed filename. So you have to first concatenate product_id with sample.jpg, then use the Send Event script step to copy that file to the default file (what you specify in the Insert File step) by means of a batch routine. Then you run Insert File, and voila your container field will be filled with the right file.

[ChasCH]

I'm trying to do this as well.

So I already have a field called "pictureData" - the value is something like "1209.jpg"

I have a folder in the same directory called "pix'. So first I tried Que's solution by making a container field "picture" with a calculation of - "image: ../pix/" & picture

nada......

Can you tell me where I'm going wrong?

Chas

[ChasCH]

oops... nevermind....

I just created two new fields in my import stack - "fileName" and "pathname" along with the "picture" container field

I then imported the .jpgs into FM7 with import folder into a table -

and lined up the "filename" -" fileName" and "pathname" - "pathname"

and that was it.... then i needed to "see" the pictures in the right place with the data so i made a relationship between the two.