Get Container Path

[ddinisco]

How do I get the path of a file that is stored 'as reference only' in a container field?

[comment]

See:
http://www.filemaker.com/help/14/fmp/en/html/func_ref1.32.239.html#1075526

 

[ddinisco]

This only returns the text name of the file. What I need is the path of the file:

/Volumes/Media1/Setups/MyFile.txt

[comment]

This only returns the text name of the file.

​No, it returns (1) the file name, (2) the absolute path to the file and (3) the relative path to the file, in a return-separated list. So =

GetValue( GetAsText ( ContainerField ) ; 2 )

will return the absolute path, for example.

[eos]

Why not browse a bit in the documentation?

http://www.filemaker.com/help/14/fmp/en/html/func_ref1.32.15.html#1063605

Edited May 15, 2015 by eos

[comment]

Why not browse a bit in the documentation?

http://www.filemaker.com/help/14/fmp/en/html/func_ref1.32.15.html#1063605

​Does the word "path" appear anywhere on that page?

Edited May 15, 2015 by comment

[eos]

And you're asking this because ...?

EDIT: I meant browse, not search, especially since there is an entire function category "Container".

GetContainerAttribute() with attribute "externalFiles" returns the path of the referenced file, even if that word wasn't used by the author.

Edited May 15, 2015 by eos

[ddinisco]

Not sure this is not working for me. This returns a blank field. If I set the value to 1, I receive just the file name, but when I set it to 2 or 3 the calc returns blank.

GetValue( GetAsText ( ContainerField ) ; 2 )

[comment]

 If I set the value to 1, I receive just the file name, but when I set it to 2 or 3 the calc returns blank.

​That's consistent with a file embedded in the container field, not stored 'as reference only'.

[ddinisco]

Makes sense, but when I click insert file I click on the checkbox to 'store as reference only'  Is there something that I need to do in the field definition of the container itself? Not sure what to try next.

 

[ddinisco]

Got it to work! Just started with a new container field and all is well. Thanks so much for you help!