Tag Archives: FileMaker

Searching for Email Addresses in FileMaker


The @ symbol used in email addresses has a use in FileMaker that predates email. FileMaker started using this symbol as a wildcard to search for missing characters. For instance if you were looking for something that ends in ‘smith’, you could search for @smith, which would bring up silversmith and goldsmith etc. Apparently, database […]

Continue reading

That Syncing Feeling – the Dangers of MobileMe.


Attempting to solve one problem, many new problems are created. For the TL;DR crowd – bought MacBook Air (MBA) on sale, setup MobileMe syncing between MBA and MacBook Pro, decided MBA too limited. Decided to return and in preparing to return to store deleted all of my contacts, calendars and bookmarks, Time Machine saves the […]

Continue reading

FileMaker MailChimp Integration – Part 3 of 4


UPDATE: 2013-06-20 FileMaker 12 version of the demo is available that should work with Windows. UPDATE: 2012-08-07 Windows users with FileMaker 12 have an option to solve the JSON error message issue by swapping out the Web Viewer steps and instead employ the new Insert from URL script step. This will save a few lines of code […]

Continue reading

Shortening URLs using FileMaker


Update: 2012-11-27 At the request for reader Robin, I had a closer look at this and it seems that both Google and Bit.ly have gone to POST method (rather than the simpler GET method) and are more locked down. They both now require an API key. You could build a method for this approach, but […]

Continue reading

How to Clear a Saved Password in FileMaker


Saved your password and can’t get to it? Here is how to get it ‘unsaved’ “Remember this password in my keychain” clicked accidentally? Sometimes, whether accidentally or intentionally, users will click the ‘Remember this password in my keychain. I usually recommend, especially for laptop users, that they not check this option, because then password control […]

Continue reading

Growl Integration with FileMaker


FileMaker dialog boxes can be informative, but sometimes they are just annoying. You have to click them to get them to go away. Lots of times, you just want to give a little bit of feedback to the user, so they they get a clue as to what your scripts are doing, without requiring them […]

Continue reading

MailChimp Integration with FileMaker Pro – Part 2 of 4


UPDATE: 2013-06-20 FileMaker 12 version of the demo is available that should work with Windows. UPDATE: 2012-08-07 Windows users with FileMaker 12 have an option to solve the JSON error message issue by swapping out the Web Viewer steps and instead employ the new Insert from URL script step. This will save a few lines of code and […]

Continue reading

ScreenSteps vs MacSnapper


UPDATE: 2014-07-31 – ScreenSteps has gone to a subscription model. Following in the footsteps of Adobe, FileMaker and others, presumably, they are trying to set themselves  to be a sustainable enterprise going forward. Their pricing is quite high for individuals, as their target market now seems to be corporations, rather than mom and pop’s software developers. Their […]

Continue reading

Minor FileMaker Security Breakdown


Note: 2012-07-14 I just tested this security ‘workaround’ in FileMaker 12 and it continues to exist. Open a File The Admin user launches a file. Using Admin level access The Admin user is set to [Full Access] privileges. Full Access means that the user can add/edit/delete any of the fields, scripts, layouts, users, privilege sets […]

Continue reading