How to get the filename of an item stored externaly with the container field
I'm using the new Filemaker Pro 12 to build a product database off-line (in the office) and then exporting the date to a remote server for our on-line e-commerce system.
In the office, without internet, we want to use the Container field to store and manage images and other file types with the External container feature. When syncing the filemaker database with our website host service, we'll just upload the images in the external folder onto the server (with FTP). However I want to try and generate a file name and path with a calculation in Filemaker which will then be used as a URL in the website server.
My table would then have the following two fileds:
- Files (Container type with Data stored externally)
- URL (Calculation that would generate a url using the filename for the file in the container field)
I looked at the GET functions, but couldn't see something I could use so any help would realy be appreciated.
Thanks in advance.