Download Demo File Recently, I was explaining the Pick List technique for a friend and thought there might be a good example online, but couldn’t find one, so here is my version. This is a pretty simple technique and can be adapted to many different aspects of a solution. Whenever you want to get data […]
Continue reading
Tag Archives: FileMaker
Simple Pick Lists in FileMaker Pro
November 7, 2022 
Comments Off on Simple Pick Lists in FileMaker Pro
Adding .ics files to Calendar on iOS
July 31, 2021 Comments Off on Adding .ics files to Calendar on iOS
Try this, email an .ics file to yourself and then attempt to add it to the Calendar app on your iPhone or iPad. Does it work? It didn’t for me as of 2021-07-31. Seems like it used to work. A web search suggests that other people are having the same problem. Possibly for security reasons Apple turned this feature off?
Anyway, this has an impact on a FileMaker Go demo database I made a while back that exports .ics files. Recently a reader, Nellie, wrote to say:
Continue reading Searching for Email Addresses in FileMaker
April 12, 2012 Comments Off on 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.
January 4, 2011 4 Comments
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
September 15, 2010 22 Comments
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
September 6, 2010 5 Comments
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
August 23, 2010 Comments Off on 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
August 12, 2010 4 Comments
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
July 14, 2010 29 Comments
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
July 5, 2010 4 Comments
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
June 21, 2010 Comments Off on 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
HomeBase Software 