FileMaker Custom Function for File Path to @Dropbox

From the second version of my first database (back in 2002) I have used my FileMaker databases to control the creation of a structured folder system to enable the efficient and uniform storing of structured data for each of the businesses I have worked with. Early on in my development of FileMaker systems I stumbled […]

Default @Dropbox File Paths

So I needed to know the default file paths for dropbox on the Mac and different versions of Windows for a Filemaker Custom Function I’m building and couldn’t find a simple listing anywhere on the internet so if you’re interested here they are: Default Dropbox location on Mac OS X: Macintosh HD/Users/YourUserName/Dropbox/ or more quickly […]

FileMaker Custom Function for formating Date Separators

I’ve finally created from scratch my own custom function for date formatting, I’ve appropriately called format.date (renaming my earlier format.date custom function to format.versions.date) as all it does is replace the date dividers or separators “.” and “-” with a standard “/”. So here it is: format.date (theDate) Let ( _divider = “/”; GetAsDate ( […]

Exporting to vCard from FileMaker

FileMaker doesn’t offer the same level of system integration with OS X as it’s little brother Bento, although it offers more power. It is possible, however, with a little work to extract the data you want to use, in the format you need. The advantage of being able to export a contact to a vCard […]

FileMaker Custom Function for Initials

So in my last blog post you’ll of noticed that I used a custom function called format.initials. I used the function in my calculated field: c_Postal_Name so that I could extract the initials from a name. Custom functions are a great way to reuse FileMaker code again and perform the same function on multiple fields. […]