Download FileMaker Pro for macOS

If you’ve ever nudged a Numbers spreadsheet past its breaking point—adding too many cross-references, wishing a cell could trigger a real action—FileMaker Pro is the logical next tool. It’s a low-code environment where you drag and drop to build custom apps for CRM, project tracking, asset libraries, and more. The 2024 release (version 21.0.1) folds in some clever AI smarts, but the real joy is how quickly a blank file turns into something useful. Here’s where to start.

• Steal from a Starter template. The built-in templates cover contacts, inventory, and content management. Open one, poke around, then bend it to your own purpose.
• Try a semantic find. New in this version, Perform Semantic Find lets you search in plain language instead of crafting a precise query. It’s a forgiving way to dig through messy data.
• Drag a field onto a layout. Switch to Layout mode, grab a field from the inspector, and drop it. Shapes, buttons, and tab panels work the same way—no code required.
• Connect the iOS app. FileMaker shares in real time. Open your file on a Mac, then open the same file on an iPad. Changes appear on both screens instantly.
• Configure an AI account. Head to the new AI setup, connect an account, and you can start experimenting with embedding vectors for smarter searches later on.

These five moves get you past the blank-screen moment. Once you’ve shaped a layout and connected a device, the rest of the feature set starts to make sense on its own.

tweak the defaults first

Fresh out of the box, a few preferences deserve an immediate nudge. Open Preferences from the FileMaker Pro menu, then flip these:

• Show recently opened files. Bump the number to 10 or 12. It saves hunting through folders when you're flicking between a handful of client apps.
• Text handling. Under the General tab, tick Use smart quotes only if you live in a word-processing field. Unticked keeps data exports cleaner.
• Layout mode grid. Switch to Layout mode, then View > Grid > Grid Settings. Set a minor spacing of 4 px. Objects snap with less jitter when you are nudging fields around.
• Field entry behaviour. In Layout mode, select a field, open the Inspector, and flip to the Data pane. Under Behaviour, uncheck Allow field to be entered in Browse mode for calculated fields and summary labels. It stops accidental clicks turning a read-only number into a blinking cursor.

small moves you’ll wish you knew earlier

FileMaker is full of tucked-away shortcuts that feel like secrets once you stumble on them. A few worth learning in your first week:

• Quick find across everything. Hit Cmd-F in Browse mode. Type a word or number, press Return. It scans every field on the current layout. No script, no relationship needed.
• Duplicate a record with a keystroke. Cmd-D clones the current record. Brilliant for data entry where most fields repeat and only one or two change.
• Hold Option while dragging. In Layout mode, Option-drag any object to duplicate it instantly. Works for fields, buttons, tab panels, even grouped sets.
• Script workspace on a second screen. Drag the script editor window to another display. You can tweak a script and test it in Browse mode without window-shuffling.
• Replace field contents in bulk. Found a set of records? Use Records > Replace Field Contents to push a value, a calculation, or a serial number across the whole found set in one hit.

None of these are flashy, but they cut the quiet friction that builds up over an afternoon of layout work.

dragging tasks across a kanban board from the starter template

Imagine you need a lightweight app to track editorial assignments. Here’s how a first session might flow.

You open the Project Management starter template from the launch window. The dashboard already shows tasks in a Kanban board, but the columns don’t match your workflow. In Layout mode, you rename the status labels—Draft, Review, Scheduled, Published. A few Option-drags copy the card fields you need.

Back in Browse mode, you add three real assignments. The Kanban cards shift as you drag them between columns. You realise the cards look cramped, so you hop back into Layout mode, widen the card shape, and pull the due-date field up next to the assignee. It takes under a minute.

You want a quick view of everything due next week. You type “next week” into the search bar and Perform Semantic Find surfaces records you’d normally need a date range to catch. One assignment is mis-tagged; you fix it and keep moving.

Before lunch, you open the file on an iPad. The same Kanban board appears, live. You drag a card into Review while someone else watches it update on the Mac back at your desk. The session ends with a saved layout, three records, and a template that now actually fits the team’s rhythm.

FileMaker sessions tend to feel like that—small bursts of building, then testing, then a quiet moment where the thing you shaped just works.

• Configure AI Account — hook up an AI service directly in settings
• Insert Embedding — store and work with vector embeddings in a field
• Insert Embedding in Found Set — batch-process embeddings across a whole found set
• Perform Semantic Find — search records using natural language instead of query logic
• Set AI Call Logging — toggle logging for AI operations

• macOS 10.14 or later
• Intel or Apple Silicon Mac