FileMaker™

My New FileMaker Book

My New FileMaker Book

It’s taken a very long time indeed but FileMaker & You, Volume 1 is finally finished. 200+ pages of step-by-step guides, tutorial videos and many expert level tips, tricks and techniques that you can quickly and easily implement in your solutions. FileMaker & You has primarily been written for the novice to intermediate developer, many of whom are likely to be working as in-house...

read more

The truth about spreadsheets

If you’re using spreadsheets to run your business, you’re not running your business; your business is running you and its running it badly. Watch this 3 minute video to discover why: and then if you want actual, indisputable evidence Database vs....

read more

Why FileMaker? – Video

Watch this short video to find out exactly why you should be using FileMaker™ to run your business.  Learn why it is the choice of tens of thousands of companies including Fortune 500 ones.

read more

App-titude

Everything’s an app but is an app everything. In this short video, I explore exactly what an app is and dispel some misconceptions....

read more

FileMaker™ & Accounting Programs

This 3 minute video explains the differences between accounting programs and FileMaker™ and will help you understand or explain why you should be using FileMaker™ to run your...

read more

More Date Magic

More Date Magic

In my last post, I showed you how to build a value list of available resources for a single date using guides as an example. In this one, we’re going to take it a stage further and work with a date range. For our example, we are using a property management system to manage vacation rentals.   When we have an enquiry, we enter the arrival and departure dates into global date fields and...

read more

Date Magic

Date Magic

It’s a common scenario.  You’ve got a reservation system of some kind or another and you have a limited number of resources available.  When you add a reservation (for a specific date), you want to be able to only select the resources that are available; in other words, they haven’t already been booked for another reservation on that same date. This is not a terribly...

read more

Chris Manton

Chris Manton

I found out yesterday (April 7th 2016) that Chris Manton had passed away from cancer; the FileMaker community has lost one of its giants and the world has lost one of its kindest and most generous souls. I had known Chris for some years; we had worked together briefly for ADS and had struck up a solid friendship, both of us being British, with an acerbic wit and an irreverence for most things....

read more

Relationships

Relationships

Relational databases, of which FileMaker™ is one of the best, are built around relationships.  Yes, I know that is obvious if you understand relational databases, but not everybody does.   For those who only have a very vague idea of what relationships are, below you will see the relationship graph for a reservation system that I’ve designed. The purpose of showing this is not that you...

read more

Resources

Resources

As a FileMaker™ developer, I know that it’s really easy to just focus on your own thing and not look anywhere else for solutions or tools that would help you be more efficient and/or effective.  We tend to suffer from the NIH (Not Invented Here) syndrome and view everything else with suspicion, that is, if we look at it at all. I’m constantly putting together resources and material...

read more

Why FileMaker™?

Why FileMaker™?

Of all the database applications out there, FileMaker has numerous advantages. Firstly it is cross platform which means it runs on Windows, Macs and IOS devices, using FileMaker Go (which I refer to as a thin client).  This gives any company that is using it multiple deployment options and can be used on a mixed network effortlessly.  Compare this to Microsoft’s Access which only runs on...

read more

Accounting Programs & FileMaker™

Accounting Programs & FileMaker™

There are many different accounting programs available today ranging from the very inexpensive (Quickbooks) to the very expensive (Great Plains). No matter what the cost is, they all, fundamentally, do the same thing which is keep track of the financials, or the Big Picture, for a business. What they don’t do at all well, because they weren’t designed to do it, is keep track of the...

read more
Website Apps