Container automation for quicktime

[sflynn]

I'm new here and very happy to be developing on Filemaker again.. so.... I have video editing software I'm using to export logged clip information. As part of that info, I can export a field with the file path info that describes where a video quicktime is stored on my array. I can import that into Filemaker no problem. I want to set up a container field on my layout that automatically displays the quicktime based on that file path info. Can this be done? The filepath is only the absolute path, not the one relative to filemaker. Since I have over 1000 records per project, this has to happen whenever someone selects a file. Thanks in advance for any help you might give me.

[comment]

I think this should work. Import your path into a text field, and define a calculation field (result is Container) =

"moviemac:/" & Pathfield

The calculation should return the string:

"moviemac:/volumeName/directoryName/fileName"

If you want the clips to play in their default app, change "moviemac" to "filemac".

See Help > Creating a database > Creating file paths for more information on path formats.

[sflynn]

Thanks for that. I was close... and what you said ultimately worked. But I found that when I import the data into the field from my other software, it uses a rather than a / to define the path for the file. How would you write a calculation to go through and replace all the with /?

[comment]

You don't need to replace anything in your imported data. Since you are using it as a source in a calculation anyway, just add a Substitute() to the formula:

"moviemac:/" & Substitute ( Pathfield ; ":" ; "/" )

That way it will work when you import another set, too.