Innovative Data Solutions

Category Archives: FileMaker

Fun and Games with FileMaker’s internal SQL

Recently I’ve spent some time looking at FileMaker’s internal SQL support. In this article I look at how we can use FileMaker scripting to add and delete tables from a FileMaker database.

Related Drop Down Menus In a Portal In Find Mode.

That’s easy I hear you say. If you have two fields on a layout, enter data into the first field and the second field has a drop down menu with only the values that relate to the first field. We have all done this, the drop down menu shows related values from a relationship which…

Database Syncing

When you have a database system that is designed to work on multiple sites you have a couple of options; remotely host the solution on Citrix or Terminal services, or have it local to each site and synchronize the data.

FileMaker Feud at DevCon 2011

Attention FileMaker friends and DevCon attendees: MightyData will host a contest at this year’s conference called FileMaker Feud.

Sub-summarys within portals pt III

Welcome to Pt III of the sub-summary portal tricks post. As it continues straight from the first and second posts it may be worth skimming through those here and here.

TechNet Meeting 14th June 2011

For all those UK TechNet members out there, just to let you know I’ll be giving a preview of one of my DevCon talks at the next TechNet meeting, only we’ll be expanding it into more of a workshop – so bring your laptops.

Unit Testing for FileMaker Custom Functions

Unit testing is one method we can use to ensure that our software is doing what we expect. I’ll discuss how we can apply this technique to ensuring our FileMaker custom functions are giving us the results we expect.

Extracting Data from XML without writing XSLT

If you have ever tried writing an XSLT to import data into filemaker, you will know that it is not very easy, unless you know XSLT in detail.

Sub-summarys within portals pt II

Welcome to Pt II of the sub-summary portal tricks post. As it continues straight from the first post it may be worth skimming through that post.

Report Generation in a Locked Down System

As a bespoke development company we often utilise FileMaker as a development platform to design software systems for our clients that are locked down to allow for a robust environment. The disadvantage of this is that end users are locked away from the great reporting power of Filemaker Pro.