use the GetAsText ( ) Function.
Along with the file path, it will list other details.
Or just put the container field name in the calculation and set it to return text.
As this will show other data besides the file path, you may want to use a function such as GetValue( containerfield; 2 ) to extract just the line that contains the file path.
Expanding a bit on what rdowler and Phil said, there is also to say that a STORED document do not have ( and show ) a path.
You'll be able to see the path ONLY if the document is inserted into the container by reference.
I've tried all of these suggestion but I cannot get the full path to show, I only get the file name. And GetAsTest ( field) returns just the name of the file. Oh yeah, this is FileMaker 11 on a Mac.
Did you select the "store by reference" option when you inserted the file in the container field?
I am trying to see the path to my video files as well, and want to see that without the other information, like video size. When I try GetValue( containerfield; 2 ), as Phil suggests, I get the message Too many parameters.
There is no error in that calculation... you'll need ONLY to substitute "containerfield" with the real name of your field.
Ah, got it!
Additionally, is there any way to lose the "moviemac:/Video V1/video catalog/" portion of the path?
Here is wat the field returns to me:
moviemac:/Video V1/video catalog/hd/006/clip001.mp4
On my hard drive, which is called "PassportBackup", the top level folder is "hd" - so, can I have the path just beginning at that point? i.e., "hd/006/clip001.mp4"
It would just be a little bit clearer...
Let([ path = GetValue ( YourContainerField; 2 ) ; start = Position ( path ; "/" ; 1 ; 3 ) + 1 ]; Middle ( path ; start ; Length ( path ) ) )
The trouble I am having is that the path and clip name seem to be displayed differently for different folders of movies on my hard drive.
Using the suggested expressions, one folder of movies displays perfectly. I am using lines 2 and 3 of the ContainerField, in different fields.
All of the records containing movies from a different folder on my hard drive, however, give more information in each of these lines. The movie name line displays the path. The path line displays a much longer path than the path from the hard drive to the file.
Do these clips possibly have their information imbedded differently? Can I get all records in my database to use the same format movie name and path?
Thank you again and again and again!