FILEMAKERBASICS.ADVISOR.COM -- The Advisor Guide to FileMaker Pro database basics, providing help and how-to, step-by-step solutions to do what you want, fast and easy, with FileMaker Pro database software for Windows and MacOS. --

New Know-How for Subscribers
Top 15 for 2009 Week 27

ADVISOR ANSWERS

Compute Tiered Sales Commission in FileMaker Pro

Here's how to compute sales commission when salespeople earn a higher percentage on bigger sales.

By Bob Bowers, technical editor

FILEMAKER PRO 10

FileMaker Pro 10: More than Just a Pretty New Face

The first thing you notice in FileMaker Pro’s new version is the updated and customizable status bar, but there are also a host of new and improved features that benefit users and developers alike.

By Susan Prosser, technical editor

PROGRAMMING

Getting Started with FileMaker Pro 10 Script Triggers

Kick your databases up a notch with the most powerful new feature in FileMaker Pro 10.

By Geoff Coffey, technical editor

USER INTERFACE DESIGN

Design FileMaker Navigation That Gets Out of Your Way

You Can Get There from Here

By Doug Gardner

ADVISOR TIPS

Set Up Field Validation in FileMaker Pro

Field validation is simply a way to instruct FileMaker Pro to check the contents of a field and alert the user when the data doesn't conform. Here are the basics.

By Stuart Gripman, technical editor

ADVISOR TIPS

Understanding the Mechanics of FileMaker Pro Validation

How and when does FileMaker Pro decide when to check validation?

By Stuart Gripman, technical editor

ADVISOR TIPS

Work with the Caveats of FileMaker Pro Validation

When you're writing your custom message, be very careful and deliberate with your wording, or you could end up with an incomprehensible message that only confuses users.

By Stuart Gripman, technical editor

TESTING

Error Capture and Testing in FileMaker Pro Scripts

Learn how and when to use the Set Error Capture script step, and how to script comprehensive error testing and handling.

By David Head, uLearnIT owner and principal trainer

INTEGRATION

Make the Transition from Excel to FileMaker Pro

Your knowledge of how spreadsheets work can give you a head start on getting up to speed on FileMaker Pro.

By Jonn Howell

ADVISOR TIPS

Work with FileMaker Pro Stored Finds

Find mode was once nearly indistinguishable from Browse mode (where regular data entry is performed). See how FileMaker Pro 10 eliminates this potential confusion.

By Stuart Gripman, technical editor

ADVISOR TIPS

FileMaker Pro Table View Renewed

Here's how to modify the FileMaker 10 Table view.

By Stuart Gripman

ADVISOR TIPS

Understand FileMaker Pro 10 Script Triggers

Here are the basics of how to arrange for a script to run when an event occurs.

By Stuart Gripman, technical editor

CONTACT MANAGEMENT

Enhance FileMaker Pro Contact Management with Daylite

Learn how to add powerful contact management and calendar capabilities to your FileMaker Pro solutions.

By Anton Anderson

DOCUMENTATION

Add Help to Your FileMaker Pro Database

Use tooltips and buttons to give users information about your database.

By Daniel Kaan and Geoff Coffey

ACCOUNTING

Accounting Basics for the FileMaker Developer

Facing an accounting integration project? Is the jargon too much? Learn how you can go from trepidation to celebration.

By Laura Bowyer, David Lommel, and Jason Young

FileMakerBasics.Advisor.com articles

Advisor Guide to Using FileMaker Pro

Search FileMakerBasics.Advisor.com articles

ADVISOR NETWORK

DIRECTORIES

ADVISOR ANSWERS

Here's how to compute sales commission when salespeople earn a higher percentage on bigger sales.

By Bob Bowers, technical editor

FILEMAKER PRO 10

The first thing you notice in FileMaker Pro’s new version is the updated and customizable status bar, but there are also a host of new and improved features that benefit users and developers alike.

By Susan Prosser, technical editor

PROGRAMMING

Kick your databases up a notch with the most powerful new feature in FileMaker Pro 10.

By Geoff Coffey, technical editor

USER INTERFACE DESIGN

You Can Get There from Here

By Doug Gardner

ADVISOR TIPS

Field validation is simply a way to instruct FileMaker Pro to check the contents of a field and alert the user when the data doesn't conform. Here are the basics.

By Stuart Gripman, technical editor

ADVISOR TIPS

How and when does FileMaker Pro decide when to check validation?

By Stuart Gripman, technical editor

ADVISOR TIPS

When you're writing your custom message, be very careful and deliberate with your wording, or you could end up with an incomprehensible message that only confuses users.

By Stuart Gripman, technical editor

TESTING

Learn how and when to use the Set Error Capture script step, and how to script comprehensive error testing and handling.

By David Head, uLearnIT owner and principal trainer

INTEGRATION

Your knowledge of how spreadsheets work can give you a head start on getting up to speed on FileMaker Pro.

By Jonn Howell

ADVISOR TIPS

Find mode was once nearly indistinguishable from Browse mode (where regular data entry is performed). See how FileMaker Pro 10 eliminates this potential confusion.

By Stuart Gripman, technical editor

ADVISOR TIPS

Here's how to modify the FileMaker 10 Table view.

By Stuart Gripman

ADVISOR TIPS

Here are the basics of how to arrange for a script to run when an event occurs.

By Stuart Gripman, technical editor

CONTACT MANAGEMENT

Learn how to add powerful contact management and calendar capabilities to your FileMaker Pro solutions.

By Anton Anderson

DOCUMENTATION

Use tooltips and buttons to give users information about your database.

By Daniel Kaan and Geoff Coffey

ACCOUNTING

Facing an accounting integration project? Is the jargon too much? Learn how you can go from trepidation to celebration.

By Laura Bowyer, David Lommel, and Jason Young

ADVISOR TIPS

Easily select the fields, text, lines, boxes, and graphics you want.

By Stuart Gripman, technical editor

DEVELOPMENT BEST PRACTICES

Being able to come back six months later and easily make sense of a application is what naming conventions are all about.

By Bill Heizer and John Mark Osborne, technical editor

ADVISOR TIPS

Here's how to modify the FileMaker 10 Table view.

By Stuart Gripman

What does it take to be a FileMaker Pro power user? If you've ever thought you might be one -- or perhaps doubt your abilities -- read on!

Moderated by Liz Novak, Advisor Basics of FileMaker Pro managing editor

DATABASE DEVELOPMENT

Indexing your data improves solution performance and can help you in many ways, but it can be a little tricky to figure out how it all works. Get to know the ins and outs of FileMaker Pro indexing here.

By Doug Gardner, Exoteric Inc. owner

ADVISOR ANSWERS

Learn how to convert customized form letters from a word processing program to electronic format.

By Lee Lukehart, Soliant Consulting director of training