Container Field File Path

[adyf]

Is there a Get () function to obtain the file path of an object that it is referenced in a container field?

[Lee Smith]

Get ( FilePath ) ?

[adyf]

Get ( FilePath ) ?

 

Hi Lee, does this not return the file path of the database file itself? Or can I still work with this function by adding to it somehow?

[doughemi]

I think http://forums.filemaker.com/posts/6239bd2f11 addresses this situation.

[Raybaudi]

Is there a Get () function to obtain the file path of an object that it is referenced in a container field?

 

Try this calculation:

Let([
c = YourContainerField ;
v = GetValue ( c ; ValueCount ( c ) )
];
Substitute ( v ; LeftWords ( v ; 1 ) & ":/" ; "" )
)

[adyf]

Thanks for the replies, I'll try these when I'm back at work.