04/12/2014 - Creating a Filtered Portal with Find

03/30/2014 - Using a Toggling Button to Switch a Slide Panel

03/29/2014 - Using Slider Panels in FileMaker Pro 13

02/26/2014 - How to Change the Background image and Font Size in the OS X Notes app

11/02/2013 - Clearing Your Mac Mail’s Spam Folder with Keyboard Maestro

08/03/2013 - Creating a Budget database for FileMaker Go

06/09/2013 - Use an Applescript to Clear the Spam Folder

06/04/2013 - Working with Formatted Text in a PHP web application

02/10/2013 - Jailbreak your iPhone!

09/21/2012 - Bob’s Bookshelf - 09/21/2012

04/21/2012 - Longterm Solutions Announces FileMaker 12 Hosting

10/17/2011 - We’ve doubled our speed!

07/02/2011 - Bob’s Bookshelf - 07/02/2011

01/19/2011 - A Year on the Titanic

10/15/2010 - How to Skip Forward or Backwards in iTunes

09/06/2010 - Designing FileMaker Databases for FileMaker Go

07/31/2010 - Grey Matters

07/26/2010 - FileMaker Go Arrives!

07/25/2010 - The iPad Saga

07/03/2010 - What Do Clients Want?

04/24/2010 - Creating Script Templates Using ScriptBuildingBlocks

04/15/2010 - I Helped Launch the Titanic!

02/21/2010 - Oh, the Agony of a Bad Book

01/26/2010 - Use VOIP to Make Phone Calls From FileMaker

01/03/2010 - Bob’s Bookshelf - 01/03/2010

12/26/2009 - Dreaming of Sugar Plums and iSlates

11/18/2009 - Bob’s Bookshelf - 11/18/09

10/25/2009 - Ten Must-Have iPhone Apps... and More...

10/16/2009 - A Cool Case for Script Triggers

10/10/2009 - Independence Day - How to Get It Done

10/01/2009 - Spreading the Love for the Best Customer Service

09/17/2009 - Voice Over IP (VOIP): A Technology Whose Time Has Come

08/13/2009 - Programming at 36,000 Feet

08/11/2009 - FileMaker Pro Templating

07/19/2009 - Art versus Craft: Keep the Customer Satisfied?

06/22/2009 - FileMaker 10 Certification

04/24/2009 - Longterm Solutions LLC Announces NowPublisher for Music Publishers

03/15/2009 - How to Post to Twitter from a FileMaker Database

I Helped Launch the Titanic!

04/15/2010 - Friends and clients know that for the past 6 months I’ve been frantically building a database solution for a new museum attraction in Pigeon Forge, Tennessee. The second of their museums, Titanic Pigeon Forge is a wonderful tourist destination for families; as a longtime fan of Titanic lore, I found it intriguing and captivating.

The Titanic museum looks like the ship, down to the rivets on the sides; it’s a bit more than half as tall as the original, and half as long; before you ask, no, I don’t know where the other half of the ship is... and no, I don’t know how they got that ship up on land.

The database was built in FileMaker Pro 10, and manages the entire venue (not the exhibits themselves, but every business function). There are layouts for the various sales locations--admissions, gift shop, and a remote phone room where phone orders are taken. The database allows its users to scan products, run credit cards, split orders into cash, two different credit cards, and even a gift card as well.

In addition to the point-of-sale part of the solution, there are other sections for the various parts of the company--customers, events, groups, tour operators, vendors, group and event scheduling using a drag-and-drop calendar, quotes, purchase orders, products, supplies, employees, and a huge variety of reports.

By the end of the month I will have put well over 600 hours into this project; there are 231 layouts, approximately 200 of which are viewable by users; there are over 50 separate tables of data. In addition to designing a system that is infinitely flexible, allows addition and deletion of users without any extra configuration, and which guides users through the system, I planned the system to expose certain areas only to qualified users.

For example, when point-of-sale employees log in, they see a custom dashboard, which displays messages that are just for them; from there they can only get into the POS system and nowhere else. Managers, on the other hand, can navigate farther into the system, but don’t have access to the admin section, where critical settings are stored for the entire system.

In addition, I created a method for the owner to send private messages to any of the employees; when that employee logs in, he or she sees the message, has to acknowledge it, and the owner can see at a glance that messages were delivered.

The entire system ties to the Titanic website (http://www.titanicpigeonforge.com), so when web ticket orders come in, they’re written right into the system. A forthcoming shopping cart will also use the same system, so that sales in the online giftshop will also be reflected in the same system.

There were enormous challenges with this system; I plan to write a more detailed case study of this solution, and hope to have it here in the next few weeks.

If you’re anywhere near Pigeon Forge, I strongly recommend that you plan to visit the Titanic; this is a first-rate attraction, and will provide a fun 90 minutes for both parents and kids.