Sample Files and Downloads

Sometimes you need to see something in action. The following sample files and resources are free for you to download, examine, pull apart, and use on your own.

Using the Web Viewer as a “Field” in FileMaker Go

Our customer wanted to suppress the virtual keyboard in FileMaker Go when scrolling through a read-only field with many paragraphs of text. The solution? Using a web viewer instead.

Quick Find, Error Capture, and Omit All

Scripted Quick Find and error 401 can leave seemingly inaccurate results.

Six Questions to Ask Before Hiring Your FileMaker Consultant

The Support Group has a free white paper entitled Six Questions to Ask Before Hiring Your FileMaker Consultant. Selecting the right FileMaker developer is crucial to saving you time and money.

Portals without Scrollbars

A reader asks how to create a portal paging system -- instead of showing a portal with the scroll bar, buttons take the user to the first, previous, next, and last set of records in the portal -- using filtered portals in FileMaker 11. Senior Developer Jud Wolfskill demonstrates a solution.

Webinar: Advanced Scripting and Calculations

When it comes to FileMaker Pro, calculations and scripts are your tools to "make stuff happen." In this webinar, we explore some techniques for building robust, feature-rich databases with complex calculations, powerful scripted automation, and elegant user interfaces.

Combinations: Turn Multiple Values into Records

Sometimes you want to convert a field with multiple values (paragraphs) into multiple records, each with one value. What if you have multiple such fields? In this article, we examine a script to take any number of fields and create all manner of combinations for records.

DevCon Webinar: FileMaker and Google Apps

View the recording of Chad Novotny presenting on integrating FileMaker with Google Apps contacts, calendars, and more, and download the sample files to see how it all works.

Geolocation with FileMaker Go

While FileMaker Go can't directly access the iPhone's GPS, you can use a web viewer and Mobile Safari's geolocation features to map your location.

FileMaker Does Sudoku!

We have a bunch of really smart FileMaker developers here at The Support Group who can do some clever stuff with FileMaker. To find out just how clever, our Development Director ran a contest for the entire technical staff to see who could build the fastest Sudoku puzzle solver using FileMaker. This is the result.

Creating a Watermark for Multiple Page Reports

Creating a watermark for a report that prints across multiple pages is easy, if you remember that only part of an object needs to be in the header for it to print on every page.

Creating Calendars with Portal Filters

Ever wanted to display event records in a calendar format? Of course you have! And FileMaker Pro 11 makes this so much easier with filtered portals.

Custom Function: EasyDate

FileMaker Pro 11's new OnObjectValidate script trigger provides us with the ability to control and massage data in ways we couldn't before. While this trigger is often thought of as a way of adding additional limitations and restrictions on data entry beyond the built-in validation options, you can also use it to ease and allow more flexible data entry.

Aggregating Filtered Portals

FileMaker 11's filtered portals exist don't really cooperate with aggregate calculations, as those calculations aren't "aware" of the filter. Here's a simple technique to summarize the rows ina filtered portal, using summary fields instead.

Dynamically naming a variable

FileMaker Pro 10 introduced Set Field By Name step, allowing you to use a calculation to choose the field to be edited. But where's Set Variable By Name? Here's how to dynamically name a variable using Let() and Evaluate().

Shortcut References for FileMaker Pro 11

Download a free keyboard shortcut reference card for FileMaker Pro 11.

Printing “Records Being Browsed” by default

You can use FileMaker Pro Advanced's custom menus to set a default for which records to print.

Highlight the active field with conditional formatting

Highlighting the active field with conditional formatting requires the simplest formula in the world, but HOW to use it is not so obvious.

Finding and Sorting Your Data

Chad Novotny demonstrates the use of various searching techniques, such as saved finds, comparative operators, and multiple requests.

Shortcut Reference Card for FileMaker Pro 10

Download a free keyboard shortcut reference card for FileMaker Pro 10.