FileMaker: Explore – General Tips

Select Script Options by First Performing Them Manually

When writing a FileMaker script to perform a find, sort, or export, doing it manually first can save you LOTS of time. Development manager Jeremy Kipling describes one way.

Understanding Line Indentation in Text Fields

How to get word wrapping to indent the second line, and all lines thereafter, for a standard, edit-box text field

Searching Across Relationships for “Empty” Fields

Sometimes an empty field isn't really empty, but instead means that a related record doesn't exist. Here's how to search for those instances.

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.

Webinar: Maximizing Mobility with FileMaker Go

When developing solutions using FileMaker Go for iPhones and iPads, you'll want to design your workflows and user experience to fit the way people create and consume information on the go. View the webinar with Chad Novotny.

Checking Screen Orientation in FileMaker Go

To check to see whether you are holding your iPhone or iPad in portrait or landscape orientations, use the Get ( WindowContentHeight ) and Get ( WindowContentWidth ) functions

Double-Check those Calculation Result Types

A reader asks why a calculated full name is being exported as the number 0. The answer is probably that pesky calculation result type.

Use Conditional Formatting for New Database Functionality

Conditional formatting can be a convenient tool for pointing out new database functionality for your users.

Running Totals in a Portal

Display the running count of records in a portal, and summarize number fields with running totals.

Looping Through Records

A reader asks: "What is the best way to create a script that loops through all selected records?"

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.

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.