I have needed to get the full file path for several solutions. What I do is use a free plugin (BaseElements) that has a "BE_SelectFile ("Your Prompt") function that opens a file selection window where you can navigate and select the file you want to import. The function returns the full path to the file selected. There are other functions that you can use in the plugin. http://www.goya.com.au/baseelements/plugin
One way is to create a calc field (or autoenter by calc) using: GetAsText ( File Container )
Note, however, that the File Container field in the Content Management starter solution is set to standard storage only (ie. old style FM storage, not either of the external storage options introduced into FM12), so:
1. If you drag a file into the container the default behaviour is to store the file inside the database, so the result returned will simply be the file name (since the filepath is, in effect, the field itself).
2. If you insert the file via the Insert > Picture… menu you have the option to store only a reference. If you use this option the result returned will include the filepath showing the file's current location.
3. If you set the File Container field to one of the external storage settings, then the result returned will reflect that, regardless of whether you drag the file into the field or insert via the menu—as long as you uncheck "store only a reference".
4. Even with external storage set, if you insert via the menu and check the "store only a reference" option this will override your external storage settings and the result returned will be as per 2 above.
In FM13 you can also use the calc: GetContainerAttribute ( File Container ; "externalFiles" )
This delivers the filepath only without the other values included in GetAsText ( File Container ).