Brian Dunning's FileMaker Custom Functions

FilenameContainer ( ContainerAsText )

Returns a FileMaker Container Field Filename.

  Average rating: 4.5 (28 votes) Log in to vote

Hal Gumbert   Hal Gumbert
CampSoftware
http://www.campsoftware.com

Share on Facebook Share on Twitter

  Sample input:
FilenameContainer ( Settings::LogoImage )
  Sample output:
CompanyLogo.png

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

// FilenameContainer ( ContainerAsText )
//
// Returns a FileMaker Container Field Filename.
//
// Hal Gumbert, Campsoftware.com

 

Comments

Sean   Sean, Birmingham
Apr 28, 2012
Two things. One, this is apparently dependent upon another custom function witch isn't mentioned in the description. Two, why not use use GetAsText ( ContainerField )?
 
Hal Gumbert   Hal Gumbert, Orlando, FL
Apr 30, 2012
Hi Sean,

Sorry about the dependent functions. I should have mentioned that. These two should solve that problem:
- http://www.briandunning.com/cf/997
- http://www.briandunning.com/cf/292

You can't just use GetAsText for Containers that are stored externally in FileMaker 12 since it returns different values now.
 
scott morabito   scott morabito, boston
Sep 22, 2012
Couple of issues here.

There is no ValuesRemoveEmptyValues function, but there is a RemoveEmptyValues. Also there is no ValuesFind function but there is a FindValues function. For FindValues, you'll need ListIndex. Both FindValues and ListIndex use "list" parameter that FMP12 won't allow so they need to be renamed.
 
Tux   Tux, Montreal
Oct 4, 2013
Here's a waaaay easier method, works on local and remote container fields

Let(
[
filename = GetAsText(<Your Container Field>);
filename = Substitute(GetValue(filename ; 1) ; "remote:" ; "")
];
filename
)
 
JF   JF, Montreal
Jan 7, 2015
Haaaa Merci Tux... je cherchais justement quelques chose de simple !!
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.