I'm working to add a user-selected "switch" that designates whether to store an image in a container field, or only a reference. The store and display parts are working (i.e., stored images do display properly). But I thought I would see a clear indication of what was actually in the container (image or file path). Instead, a calculated field (GetAsText(Container)) shows either the image size ... or only the inserted file name (no path).

Attached is a screen capture of my test results. Lamb and Blue were inserted using a right click + Insert Picture + Store Reference operation. The others were done without the Store Reference designation.

Shouldn't the calculation for ones that (supposedly) contain references result in something like "filewin::c:/directory/image001.png"? I read quite a bit before I implemented this, and I thought I knew what to expect. What have I missed?

Thanks for any help.

What do you see when you click into the field?

But I thought I would see a clear indication of what was actually in the container (image or file path).

Try to change the calculation with:

Case(

ValueCount ( Container ) > 1 ; "Referenced" ;

ValueCount ( Container ) ; "Stored"

)

The GetAsText() function will return multiple paragraph-delimited values, so you may only be looking at the *first* value it returns.

The GetAsText() function will return multiple paragraph-delimited values, so you may only be looking at the *first* value it returns.

Thanks to you all.

That was it. I made my test field editable and can now see the full result of the GetAsText function. I hope these examples help others resolve problems with the undocumented format of the function's results. Not only does FM's description of the function fail to mention multiple lines, it claims that embedded container data returns a question mark, which does not appear to be the case.

I do appreciate your help.