Hello!

Im trying to get the path frpm a container field into a field. I am trying with a calculation field and Im doing GetAsText(Picture) but the only thing it is returning are a ?, does anyone have any clue why this doesent work?

Regards Jocke

I tried same calculation on win xp pro and its worked.

I believe it only works with local images inserted as reference. With remote images I believe it returns just the name. With embedded images it may return the "?", as it has no idea.

The only thing I do is to mark the container and then go up under the menu Insert and then choose picture, the picture I select is on my computer. Anyone has an idea?

Jokez

Look at the checkbox on the lower left, "Store only a reference to the file." If it is not checked then you are embedding the picture itself into the FileMaker container field. Once you do that there is no longer ANY connection to the file. And FileMaker cannot use the GetAsText() function, because it requires the file path.

You can however use Length() to see the approximate size, in bytes. You could also another method, such as Import Folder, and import the File Path into a field. Or use AppleScript to get the file path. But both of these must happen when the picture is 1st inserted, because after that there is no connection to the original file.

It depends on what your situation is, stand-alone on one machine? network multi-user? which is the best overall method to add pictures. There's several methods:

1. Embed picture in FileMaker

2. Reference picture

3. Reference with calculated path

And there's more than one way to do each of those. Import Folder? Insert Picture? Insert Picture, with AppleScript enhancements? Troi File plug-in? Other?

Thanx!! That worked like a charm!!!

// Jocke

Edited September 12, 200520 yr by Guest