Insert image in container

[tsd]

Hi !

I have 1 field called Article (number), 1 field called Link (global), 1 field called Image(container), and 1 field called complete_link (calc).

Article is a number user press in.

Image will depend on complete_link.

Link is G:Images

complete link is calc: link & Article & ".jpg"

If a user press in number 12345 the complete_link field will be G:Images12345.jpg.

I want that image 12345.jpg to show up in the containerfield Image-field as

"Store only a reference to the file".

Is this possible ?

Best Regards...

[Matthew F]

I want that too! The "insert picture" script step does not allow images to be inserted based on a (calculated) field value. Is this option available in FM7?

[Matthew F]

... for that matter I would like to be able to drag and drop an image file from the finder into a container field. Despite the fat that the help files say that one should be able to do this it doesn't do anything for me. Does this work for anyone else?

[Fenton]

I don't see where it says you can drag and drop an image into a container field. Would be nice though.

Back to tsd, you can display an image with only a calculation. It is "by reference" (since the image is not "in" the database).

It is a "relative" path, like a web browser would use, not an "absolute" path, like other programming languages would use (on your own hard drive).

It can be on a mounted volume (relative and absolute paths would be about the same). I'm not sure exactly about the Windows equivalent (with the volumes), but on a Mac it would look like:

image:/volume_name/folder_path/filename.jpg

(Notice the extra "/" after "image:", which you don't use on your own hard drive; means "root" I would guess.)

Do a seach here on "Container" There have been several posts recently.

[Lee Smith]

You can drag and drop in OS 9.x, but the Image has to be open in something too. I.e. a screen shot needs to be open in Simple Text. From one FM file to another FM file, etc.

HTH

Lee

[carlschneider]

What would the path be for images stored in a folder on a website. I have tried every variation I could think of. I imagine it is something like:

image:/http://www.domainname.com/folder/filename.jpg

but this doesn't work. Does anyone know how to do this?

[Søren Dyhr]

Hi

Sorry for chiming in this late, but I stumbled over this while searching for other matter with containers.

But I've just discovered that if you have a global textfield called "gPath" could you embed following line of applescript:

set data of cell "theContainer" of current record to file cell "gPath"

...et voila a new picture is entered, at least when the fileformat fits!!! As long you keep "gPath" a global text field. I said it was a resent discovery, so I might come up with more hints later.

--sd

[Fenton]

Hi S

Images_Remote_Local2.zip

[Søren Dyhr]

The big "If" check is trying to see if it's a supported image, as many image files do not have an explicit file type. Suggestions for a better way appreciated.

I can follow you with point you made for the illegal documant types, but some sort of OS filesharing must work to reach for the images. I did try you template and nothing happend at all. So I started all over from scratch and uploaded it to my iDisc and tried to make it fetch a .pdf file on my desktop... it worked! I've put in a calc' to see the specs for the loaed image.

The way I handled it:

set theFile to choose file with prompt "Choose an Image File"

if theFile = {} then

else

try

tell current record of window 1

set data of cell 1 to theFile

end tell

on error

display dialog "Not at recognized filetype"

end try

end if

But take a look for yourself, I've uploaded it!

--sd

RemoteImageSD.fp7.zip