Experiences of a FileMaker Pro Database Developer

A Time for Thanks

It’s that time of year to celebrate Thanksgiving, to be thankful for the many blessing that we all have. This year, I have the pleasure of working with a military psychiatrist, CDR Alfredo “Devil Doc” Baker, MD, MC, USN, who is stationed in Afghanistan. He contacted me asking for help with FileMaker Pro. I thought this would be a great opportunity for me to show appreciation, in some small way, for our troops stationed abroad.

I decided to turn the project into a case study in hopes that it might help others who are also just beginning to use FileMaker Pro and want to know where to start. What you’ll find hidden in the transcripts of our correspondence is a glimpse into what’s happening with our Soldiers and how they feel about defending our Country. This experience has left me with a stronger sense of pride about the United States, as well as great appreciation and thankfulness for the men and women who serve to defend us.

I hadn’t heard from the Commander in over a week, so I sent an email asking how things were going. His response below deserves our thoughts and prayers this Thanksgiving.

Commander Baker: Hello Matthew. My apologies for taking so long to respond. We had an unfortunate event in which one of our Marines suffered a double amputation secondary to an Improvised Explosive Device (IED). This really hit us hard, especially when there is already a mental/physical fatigue due to this long year deployment. The good news is that he is doing well but as it always happens in this kind of event, not only there is a physical damage but an emotional as well. I have been taking care of those that were witness of this atrocity and trying to minimize the emotional and physical stress.

I will be working on the database this weekend. Thanks again. God Bless my friend.

If you know anyone that has served or is serving in our Armed Forces, please make sure to tell them “Thank You” this Thanksgiving.

Post to Twitter

Unresolved (

Comic relief at xkcd.com

Deep in a calculation, we’ve all been there trying to find the missing left or right parenthesis, among other things. After racking our brains, we sometimes just need a little relief and some humor to break up the day. Check out other comic relief at xkcd.com.

Post to Twitter

Normalizing Data with Google Refine

If you have messy data, try Google Refine. There is nothing like dealing with messy data that is all over the place. We often have to normalize the data before importing and this is a great tool to help with data normalization.

Post to Twitter


Highcharts are interactive JavaScript charts. These can be displayed in any browser and can also be viewed directly in FileMaker using the web viewer.

Click here to see how I recently used Highcharts. Make sure to check out the demo gallery to see all the charting options available.

Post to Twitter

Find FileMaker Developers

Looking for a developer, start here first at Find FileMaker Developers: http://www.findfilemakerdevelopers.com.

Post to Twitter

FileMaker Inc.

It’s inevitable that you’ll need to visit FileMaker’s site. Wether you need to search the knowledge base, solutions made for FileMaker (databases and plug-ins) or download resources like white papers and other technical material, this is where you’ll start.

Post to Twitter

Brian Gardner’s STUDIOPRESS

The best WordPress themes out there are by Brian Gardner and his creative team at Studiopress. The new Genesis Framework is the only way to go if you are developing a site using WordPress. Their themes are like my databases, clean, clear, concise and simple to use. Check out StudioPress here: http://www.studiopress.com.

Post to Twitter

Dr. Ray Cologon’s Demos

Ray’s FileMaker work is impeccable and a must have resource for anyone developing in FileMaker Pro. Make sure to check out his FileMaker Pro 10 Bible as well as his demos here: http://www.nightwing.com.au/FileMaker/demos.html.

Post to Twitter