If your organization relies on spreadsheets, paper forms, or multiple applications to get your work done, you might consider using a FileMaker database solution instead. A FileMaker solution can bring disparate information together in one place and make it easy to add to, change, and query the data.
At its simplest, a FileMaker solution is made up of a database and a user interface. A database is a collection of information that is organized into files called tables. A user interface lets users view and interact with the information in the database.
FileMaker solutions also allow for calculations, scripting, reporting, security, and integration with spreadsheets and other database systems.
Solutions can be big, up to 8 TB. Text fields can store up to 2 GB of text, and container fields can store up to 4 GB of binary data like images, audio, video, and PDF files.
An Excel spreadsheet is a kind of database called a flat-file database. It organizes its information into a single table. FileMaker uses relational databases. With a relational database, you store data in several tables and then define relationships between them. For example, you could store donor information in one table and donation information in another. That way you would only have to enter a donor's information once, whereas in a spreadsheet you would have to enter it for each donation. A relational database prevents duplicate information and is less prone to error than a flat file.
Chart of table relationships as defined in a FileMaker solution
FileMaker Pro offers tools to simplify designing user interfaces. Often it's as simple as dragging the fields you want to show onto a layout. You can create different layouts to show the same data in different ways. For example, you could browse donor records one at a time or view them all in one long list.
The software also contains dozens of built-in themes that use different colors, shapes, and typefaces. Some themes are designed for iOS devices and feature large, tap-friendly zones.
Same data, different themes
FileMaker Pro comes with 16 predefined solutions, called Starter Solutions. The data structures are all set up, and the layouts (components of the user interface) are all designed.
There is also a marketplace of solutions that others have built for specific purposes and sell licenses for.
You can build a custom FileMaker solution from scratch to suit your particular needs. FileMaker Pro makes this fairly easy because you don't have to know SQL, the underlying programming language of most database systems. You still have to know your way around data structures, though, and understand how to relate tables to one another. You can learn this from the training included with FileMaker Pro and from other sources.
This list of Starter Solutions might give you an idea of ways your organization could find FileMaker helpful.
This list is subject to change but was current as of publication of this article.
You can also look at the nonprofit customer stories on the FileMaker website. And see this story from the TechSoup blog about how an eye bank puts FileMaker to use.
The following components make up the FileMaker Platform. FileMaker offers the first two of them, FileMaker Pro and FileMaker Server, at a discount through TechSoup.
FileMaker Pro is a desktop application for designing and building custom solutions and using them once they are built. It runs on both Mac and Windows.
FileMaker Server hosts FileMaker solutions. It can also perform tasks like backing up automatically and logging statistics on usage and performance. You need the server if you have more than five people who will be connecting to a solution with FileMaker Pro or FileMaker Go.
FileMaker Pro Advanced adds features to FileMaker Pro, including tools for script debugging, customizing the product, and documenting a solution's internal structure.
FileMaker Go gives you access to FileMaker solutions on iOS devices. This capability is especially valuable for collecting data in the field, taking the place of clipboards and paper. You can also add photos, audio, video, and signatures. The connection can be made through Wi-Fi or a cellular connection, or the changes can be stored on the device and then synchronized later. FileMaker Go is a free app.
FileMaker WebDirect gives users access to FileMaker solutions in web browsers. FileMaker WebDirect is a feature of FileMaker Server, which must host the solution. The solution must be created in FileMaker Pro, but web users don't need to have it. See this comparison of what can and can't be done with WebDirect.
If five or fewer people will be using the solution on a single computer or a peer-to-peer network, you will need a FileMaker Pro license for each user. You can request four discounted FileMaker Pro licenses through TechSoup each fiscal year.
If you need more than four discounted FileMaker Pro licenses in one year, you can request them directly through FileMaker.
Please note that for FileMaker licenses fulfilled through TechSoup:
If more than five people will be using a FileMaker solution, you will need to host it on FileMaker Server. You can request one discounted FileMaker Server license through TechSoup each fiscal year.
If you host a solution on FileMaker Server, a FileMaker Pro license allows you to connect to it. However, if you connect to it using FileMaker Go or FileMaker WebDirect, you need to obtain paid connections directly from FileMaker. The server comes with one connection for testing purposes. You buy others in groups of five, up to a maximum of 100. For example, if 12 FileMaker Go and WebDirect users connect to your solution at peak times, you will need to buy 15 concurrent connections.
With version 15, FileMaker introduced "user connections." The previous "concurrent connections" are still offered if needed.
FileMaker's training page lists a number of resources, many free, for learning how to use the platform.
Image 1: Intel Free Press / CC BY-SA
Images 2, 3, and 4: FileMaker
Join today to access donations and discounts for your nonprofit or library.
Already a member?