

This also means that FileMaker must be running with the database open if you want to to use the client-server approach. FileMaker is a real server application this is not just file sharing. The advantage of running locally is offline use, whereas the advantage of the client-server model is that all users have the most up-to-date version of the data, and the database can be much larger. Transferring a file is easy using iOS launch service essentially, if you can access the file via the internet or an email attachment, you can just tap it on the device and it will open in FileMaker Go. FileMaker Go can open a file hosted by FileMaker desktop or server, in which case it behaves like a Mac or Windows client, or alternatively you can transfer a file to FileMaker Go to run locally.

What this means is that you can create apps in FileMaker Pro and deploy them to iOS without going via the App Store. Anyway, FileMaker Go is in the App Store and does run scripts. Well, either someone decided that FileMaker scripts are not code or there are special rules for an Apple subsidiary, which is reasonable enough. This is normally taken to prohibit runtimes like Java or Adobe Flash/AIR. Given that FileMaker runs scripts you might have thought this would be restricted, bearing in mind this provision in the App Store guidelines:Ģ.7 Apps that download code in any way or form will be rejected I have not looked at FileMaker for a few years, but renewed my interest when the company came out with FileMaker Go, a runtime client for Apple iOS. Security is fine-grained, and you can even specify permissions for an individual record. FileMaker has its own built-in security system, though FileMaker server can also authenticate against an external directory. The desktop product supports up to 5 concurrent users, and FileMaker Server up to 250 users. The number of users supported by FileMaker is limited.

External databases are accessible through ODBC on both Windows and Mac. As well as manipulating the data, you can set and retrieve local and global variables, perform loops and display custom dialogs it is not as limited as it may seem at first.Ī FileMaker database can be huge, with 8 terabytes specified as the theoretical limit. FileMaker has a drag-and-drop script editor and support for AppleScript on the Mac.Īlthough the script editor is frustrating for someone used to writing code, it does work. In comparison to Microsoft Access, FileMaker wins on usability and scalability, but Access has a more traditional approach based on SQL and programming with Visual Basic for Applications. FileMaker has evolved relatively slowly, with more focus on usability than on features. It is a capable produce that has been around for over 20 years and is the dominant Mac-based database manager, though there is also a Windows version.

FileMaker Pro is a database manager from FileMaker Inc, a wholly owned subsidiary of Apple.
