FileMaker Custom Functions
Expand FileMaker Pro with Custom Functions. Create a new custom function in FileMaker, enter the name and attributes of the corresponding bold header below, click the Select button below the text area, copy the highlighted text, and, paste it into the custom function calculation field. The code comments have usage instructions.
FileLib FileLib is a free AppleScript library of essential folder and file routines for use in AppleScript scripts and applications. FileLib Handlers WriteToFile ( _data , _filename , _append ) – Write data to filename and either overwrites the filename … Continue reading →
PlistLib PlistLib is a free AppleScript library of essential functions to manage preference list files from within AppleScript code. Use System Events and some “defaults” shell script plist commands to manage plist’s from within AppleScript scripts and applications. Verify, create, … Continue reading →
PathParser ( thePath , returnElementPHFNE ) PathParser returns the path directory, home directory, full filename and extension, filename, or extension from a folder and/or file path string. Easily extract path elements from thePath. Preserves FileMaker Pro file reference prefixes (file:, … Continue reading →
PathMaker ( thePath , theFile , pathSeparator ) PathMaker returns a properly formatted folder and/or file path by processing and combining thePath, theFile and pathSeparator. Easily change path separator in thePath. Preserves FileMaker Pro file reference prefixes (file:, filemac:, and … Continue reading →
MailSaver saves Apple Mail messages to uniquely named files. MailSaver automates the task of saving Apple Mail messages to custom-named files. MailSaver controls Apple Mail with AppleScript to save one or a group of e-mail messages to a choice of … Continue reading →
GetValueIndexByPosition ( valueList , valueString , matchCase , occurrence , positionLCR ) GetValueIndexByPosition retrieves the index of the value in a value list whose left, center or right portion matches the value string search text. Returns 0 if not found. … Continue reading →
Easter ( theYear , method ) Easter custom function returns Julian, Orthodox, or Gregorian Easter dates for years 326 to 4000 (or 4099). Year validation changes the year to the minimum year that can be calculated for the calendar method. … Continue reading →
NPVV ( cashFlowsList , interestRate ) NPVV calculates Net Present Value of a value list of cash flows (cashFlowsList) with a specified rate of return (interestRate). Used to determine the present value of an investment by the discounted sum of … Continue reading →
IRR ( cashFlowsList , guessRate ) IRR calculates Internal Rate of Return of a value list of cash flows (cashFlowsList) using an initial guessed rate of return (guessRate). The parameter guessRate defaults to .0001 if initially blank. IRR calculates the … Continue reading →
FormatNumber ( number , format ) FormatNumber is a one-pass FileMaker Pro custom function that formats a number using intuitive, free-form format options that completely mimic FileMaker Pro’s number data type formatting. Formatting options can also be specified via escaped … Continue reading →