HI I have

FMP 12 Advanced...

One of the starter solutions is "content management"

however when I change the storage system to "outside the database" the filename Placeholder field goes all odd and shows the path… size etc of the file…
How can I just get the file name for this field …?

This will do it:

 

Let( [

var1=GetValue( Documents::Doc_Container ; 1 ) ; 

var2=Length( var1 )

] ; 

 

Right( var1 ; var2 - 7 )

)

How can I just get the file name for this field …?

Hi

 

you'll need to change the calculation for the field: File Name Placeholder to:

Case( 
IsEmpty ( File | Container ) ; "File" ; 
ValueCount ( File | Container ) = 1 ; File | Container ;
Let( v = GetValue ( File | Container ; ValueCount ( File | Container ) ) ; Middle ( v ; Position ( v ; "/" ; Length ( v ) ; - 1 ) + 1 ; Length ( v ) ) )
)