You are here: Advisor.com » Advisor Guides » FileMaker Advisor » The Advisor Guide to FileMaker Pro database software for advanced users and solution developers, covering FileMaker Pro, FileMaker Advanced, FileMaker Server, FileMaker Mobile, and more, for Windows and MacOS.
My.ADVISOR.com Sign-In
Username
Password
Sign-Up 
Go to Article
Advanced Search 
In Print
APRIL / MAY 2008
FILEMAKER ADVISOR MAGAZINE cover
New Know-How for Subscribers
Top 15 for 2008 Week 19

ADVISOR ANSWERS

Do Complex FileMaker Pro Finds Using Related Data

By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

SCRIPTING

Good Catch! 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

WEB DEVELOPMENT

Create Conditional Value Lists with FileMaker.php and AJAX DOWNLOAD

Make your FileMaker/PHP Web application shine with AJAX.

By Jonathan Stark, Jonathan Stark Consulting

ADVISOR TIPS

FileMaker Pro Certification

Why are 173 FileMaker Business Alliance (FBA) members and countless other in-house developers certified for FileMaker Pro 7, 8, and 9? Find out here.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR TIPS

Create a Modification Host Timestamp in FileMaker Pro

Learn how to auto-enter the modification timestamp from the host when a user modifies any field on a record.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

DATABASE DEVELOPMENT

Stay Sharp! Nourish Your FileMaker Pro Skills with the Right Development Diet

What constitutes good nutrition for creative, professional, responsible FileMaker Pro developers? Find the right blend of programming activities to keep you interested and growing, while providing the greatest value to your company.

By Michael Reddy, Ph.D.

ADVISOR TIPS

Track FileMaker Pro Layouts with an Array

Whether you're a newbie or a FileMaker Pro guru, you'll undoubtedly have to provide scripted buttons to navigate through the plethora of layouts in your solution. Find out how.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR TIPS

Create a FileMaker Pro Folder

Learn how to create a directory or folder on the local hard drive from a FileMaker file natively.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR TIPS

Create Multiple-Field Self-Building FileMaker Pro Value Lists

Have you ever found yourself creating essentially the same value list for two or more separate but similar fields? Use this tip to save some time in those cases.

By William Bombardier, Minneapolis, Minnesota

ADVISOR ANSWERS

Embed QuickTime Movies in a FileMaker Pro Database

Learn an alternative to the container field that lets you embed QuickTime movies in a database.

By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

REPORTING

Complex FileMaker Pro Reporting? It All Depends! DOWNLOAD

Make reporting easier for users with this application of conditional value lists.

By Michael T. Rocharde

FILEMAKER.PHP

Display FileMaker Pro Multi-Field Value Lists on the Web DOWNLOAD

Learn how to use the FileMaker API for PHP to build and display complex value lists

By Jonathan Stark, Jonathan Stark Consulting

DATABASE DEVELOPMENT

In-House and Consultant Developers Collaborate to Create Better Solutions

In-house and consulting developers tend to be experts on different, complementary pieces of the software development picture. Learn how to bring these talents together to build more and better FileMaker Pro solutions.

By Michael Reddy, Ph.D.

FILEMAKER PRO 9

Conditionally Format Layout Objects in FileMaker Pro 9 DOWNLOAD

Create better layouts and help users navigate your solutions by putting the conditional formatting feature to work.

By Paul T. Mitchell, Soliant Consulting technical lead

ADVISOR ANSWERS

Complex Multi-Column Publishing in FileMaker Pro DOWNLOAD

Discover a solution to a complex printing problem.

By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

FileMaker Advisor articles

REPORTING

Complex FileMaker Pro Reporting? It All Depends! DOWNLOAD

Make reporting easier for users with this application of conditional value lists.

By Michael T. Rocharde

FILEMAKER.PHP

Display FileMaker Pro Multi-Field Value Lists on the Web DOWNLOAD

Learn how to use the FileMaker API for PHP to build and display complex value lists

By Jonathan Stark, Jonathan Stark Consulting

DATABASE DEVELOPMENT

In-House and Consultant Developers Collaborate to Create Better Solutions

In-house and consulting developers tend to be experts on different, complementary pieces of the software development picture. Learn how to bring these talents together to build more and better FileMaker Pro solutions.

By Michael Reddy, Ph.D.

FILEMAKER PRO 9

Conditionally Format Layout Objects in FileMaker Pro 9 DOWNLOAD

Create better layouts and help users navigate your solutions by putting the conditional formatting feature to work.

By Paul T. Mitchell, Soliant Consulting technical lead

ADVISOR ANSWERS

Complex Multi-Column Publishing in FileMaker Pro DOWNLOAD

Discover a solution to a complex printing problem.

By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

DATABASE DEVELOPMENT

In-House and Consultant Developers Collaborate to Create Better Solutions

In-house and consulting developers tend to be experts on different, complementary pieces of the software development picture. Learn how to bring these talents together to build more and better FileMaker Pro solutions.

By Michael Reddy, Ph.D.

APPLICATION INTEGRATION

Manage Your Contacts: Import vCards into FileMaker Pro DOWNLOAD

Are your contacts getting out of control? Find out how to get all the valuable information from your vCards into a FileMaker Pro database.

By Roger Jacques, Soliant Consulting

ADVISOR ANSWERS

Polish FileMaker Pro Solutions with Scripting

Want to spiff up a solution? Scripting is the answer. Find out how scripting can help your solutions look great.

By Lee Lukehart, Soliant Consulting director of training

Speed Up -- and Simplify -- FileMaker Pro Date and Time Searches

Learn some shortcuts that can have you finding just the right data with few keystrokes.

By Jason Mundok, IT Solutions Consulting project manager and FileMaker developer

ADVISOR TIPS

FileMaker Pro Super Search

The super search is a method for quickly searching several fields without having to enter Find mode. Learn how to use it.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

REPORTING

Create FileMaker Pro Reports Without Using Finds

Make reporting easy for users with a technique that builds complex reports using relationships, not finds.

By Michael T. Rocharde, Excelisys lead programmer

ADVISOR TIPS

Applied Conditional Formatting in FileMaker Pro

Learn an innovative technique that wouldn't have been nearly as elegant before FileMaker Pro 9.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

ADVISOR ANSWERS

Make Magic with FileMaker Pro Buttons

Finesse your buttons by making the highlight the same shape as the button.

By Lee Lukehart, Soliant Consulting director of training

Automate Navigation with FileMaker Pro Open Scripts DOWNLOAD

Help users see the correct information when they first open your FileMaker Pro solution.

By Paul T. Mitchell, Soliant Consulting technical manager

ADVISOR ANSWERS

Explore FileMaker Pro Set Variable Script Step

Find out when you'd use Set Variable, and what the difference is in variable names starting with $ versus $$.

By Lee Lukehart, Soliant Consulting director of training

ADVISOR TIPS

FileMaker Feature Requests

What are your ideas for future enhancements to the FileMaker product line?

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR TIPS

Rounding Time Values in FileMaker Pro

Writing calculations that round time requires you to know how FileMaker Pro stores time. Find out what that is, and what formulas you can use.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR ANSWERS

Wrangle FileMaker Pro Sliding Objects and Container Fields

Say you have a database that uses container fields to display PDF files and you want to print from a list view. In cases where there is no PDF in the container field, you want the next full container field to slide up and take the space occupied by an empty one. Find out how to make this work.

By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

ADVISOR TIPS

New FileMaker Pro Training Series

Find out how the courseware has been revamped to focus on the development aspects of FileMaker Pro.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR TIPS

Understand FileMaker Pro Record Locking

Understanding all aspects of record locking is extremely important to producing a professional FileMaker Pro solution. Find out what you need to know.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR ANSWERS

Create a Complex Scripted Find in FileMaker Pro

Learn how to let users add names to one table, then perform a find in another table that automatically omits anyone in the first table.

By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

FILEMAKER 9

Open Up! Integrate SQL Sources in FileMaker Pro 9

External SQL Source integration is one of the major changes in FileMaker Pro 9. Find out how to use it, when to use it, and what to look out for.

By Steve Lane, Soliant Consulting vice president

COMPLIANCE

Implement FileMaker Pro Database Change History

Discover a range of audit logging techniques to help you meet compliance mandates, while also making data backup and recovery easier.

By Jason Erickson

ADVISOR ANSWERS

Update FileMaker Pro Value Lists Without Scripts DOWNLOAD

Say you use a value list to add products to an order. How do you get the value list to change so after you add an item to the order, it disappears from the value list? Find out here.

By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

ADVISOR ANSWERS

Polish FileMaker Pro Solutions with Scripting

Want to spiff up a solution? Scripting is the answer. Find out how scripting can help your solutions look great.

By Lee Lukehart, Soliant Consulting director of training

FileMaker Developer Conference 2008

July 13-17, 2008, Phoenix, Arizona

Mark your calendar now!

Experience FileMaker DevCon

Learn from the Experts

Learn from the Community

Learn what you've been missing

The developer answers you need are in FILEMAKER ADVISOR. Click here to subscribe now.

NEW: If you're new to FileMaker, or not ready for advanced developer advice, check out ADVISOR BASICS of FILEMAKER PRO -- the how-to journal just for you.

ADVISOR TIPS

Remove FileMaker Pro Return Characters

Learn a new twist on a technique for removing leading and trailing carriage returns from a text field.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

WEB DEVELOPMENT

Sell Your FileMaker Pro Solutions with PayPal DOWNLOAD

Learn how to integrate the Web viewer with PayPal to automate software sales.

By Michael Petrov, FMWebschool partner

Maximize Screen Space with FileMaker Pro Tab Controls DOWNLOAD

Learn how to organize limited screen real estate and prioritize data with the tab control tool.

By Susan Prosser, technical editor

Export Data from FileMaker Pro DOWNLOAD

You probably aren't lucky enough to work with organizations that are exclusively using FileMaker Pro. What happens when you need to share information with them? Find out how easy it is to export data into other file formats.

By Mary Conohan, School Base senior developer

When to Build, When to Buy FileMaker Pro Solutions

Sure you can create FileMaker Pro solutions to help with day-to-day business needs. But when do you call in help from a professional?

By Michael T. Rocharde

Put Multiple FileMaker Pro Windows to Work

Handling windows in FileMaker Pro can seem confusing at first, but with a few tips, you can be on your way to more efficient data management.

By Geoff Coffey, Six Fried Rice partner, and Advisor Basics of FileMaker Pro technical editor

ADVISOR TIPS

Valuable Value List Tips

Data entry can be a grind, so do what you can to help out those who are using the databases you create, by giving them value lists.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

TECH NEWS

FileMaker Pro 8.5v2 Update Fixes Leopard Compatibility Issues

Update fixes problems that caused FileMaker Pro 8.5 to hang when system language and region didn't match, and when saving to or exporting to Microsoft Excel format.

ADVISOR TIPS

Delete FileMaker Pro Files Elegantly

Find out how to delete a file from your local hard drive or a shared volume using a couple of script steps.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

TECH NEWS

Productive Computing Change Printer Plug-in for FileMaker Pro

Coordinate large and complex print procedures and switch between different types of printers/drivers.

FILEMAKER.PHP

Deliver Secure Web Applications with PHP and FileMaker Pro DOWNLOAD

Learn how to use PHP to process a user login and to maintain a session for logged-in users.

By Jonathan Stark

TECH NEWS

FM::Nexus Dragon Web Surveys 8 for FileMaker Pro

Survey solution supports multiple languages, provides custom cascading style sheets support, has visual reporting statistics, and more.

ADVISOR TIPS

Hide FileMaker Pro Field Labels

Learn how to hide field labels underneath a field, without having to add a calculation field for every field label.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR TIPS

Sort FileMaker Pro Portals

Learn how to sort portals by multiple independent field types using the Tab Control feature, without any tricks to hid the tabs.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

APPLICATION INTEGRATION

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

ADVISOR TIPS

Resize FileMaker Pro Portal Rows

Using the autoresize feature in FileMaker Pro 9, you can have any object resize with the size of the window, including portals. Find out how.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

USER INTERFACE

Psychology of Effective FileMaker Pro Solution Design

Creating user interfaces that are easy to learn and efficient to use requires an understanding of the psychology we all share. Use these techniques to build FileMaker Pro solutions users can effectively navigate and use, and that enhance confidence in you and the product.

By Don Levan, Psy.D., Vanguard Custom Software president

TECH NEWS

WorldSync fmDataGuard Gives FileMaker Pro Solutions Audit Technology

Logging View data, instant data rollback, and recovery from crash or corruption among compliance capabilities.

ADVISOR INTERVIEW

FileMaker 9: Fine for IT

FileMaker Pro 9 works well in corporate environments. See how to make the most of it.

Interviewed by Elizabeth Novak, managing editor

ADVISOR TIPS

Highlight a FileMaker Pro Field

Learn how to highlight a field as soon as you click or tab into it.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR ANSWERS

Auto-Enter Based FileMaker Pro Script Execution

Learn how to use an example plug-in from FileMaker Pro 9 Advanced to run a script to add an extra handling charge to an invoice.

By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

FILEMAKER.PHP

Create Subsummary Reports on the Web with FileMaker 9 and PHP DOWNLOAD

Add context to your data quickly and easily without adding summary fields to your tables.

By Jonathan Stark

ADVISOR TIPS

Highlight a FileMaker Pro Record

Find out how to highlight the currently active record in list view without a script or plug-in.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR ANSWERS

FileMaker Pro Portal Filtering

Find out how to build a project detail layout that has two portals.

By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

MOBILE DEVELOPMENT

Create a Web 2.0 FileMaker Pro Solution for iPhone DOWNLOAD

Learn how to build a slick looking, high-performance application to pull FileMaker Pro data to an iPhone.

By Brian Dunning, FileMaker Advisor technical editor

ADVISOR TIPS

FileMaker DevCon 2007 Highlights

If you didn't make it to the 2007 FileMaker Developer Conference, find out what you missed.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR TIPS

Create FileMaker Pro Animated Windows

Learn how to make a FileMaker Pro window appear to unroll itself like a scroll.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

REPORTING

Create More Powerful Reports in FileMaker Pro 9 DOWNLOAD

With FileMaker Pro 9's new Append to PDF feature, you can easily produce complex reports by assembling several layouts and found sets into one seamless PDF file.

By Geoff Coffey, technical editor

ADVISOR TIPS

Create Better Layouts with FileMaker Pro Alignment Tools

Learn how to use the alignment tools in FileMaker Pro for neat and orderly layouts.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

ADVISOR TIPS

Discover the FileMaker Pro History Eraser Button

It's nice that FileMaker Pro can save your layout changes automatically, but what do you do if you mess things up in a layout so much that an Undo command isn't enough to get you out of the jam? Find out here.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

MIGRATION

Advantages of FileMaker Pro Over Spreadsheets DOWNLOAD

Many people are more comfortable with using a spreadsheet than they are with databases, regardless of the limitations of spreadsheets. Learn how to help make the case for using FileMaker Pro.

By Michael T. Rocharde

PROJECT MANAGEMENT

Agile FileMaker Pro Development

Learn a project management methodology that helps you build stronger relationships with your customers, deliver more accurate custom software quicker, and prevent misunderstandings that would otherwise derail a project.

By Jason Mundok, IT Solutions Consulting, Inc. FileMaker consultant and manager of training services

ADVISOR TIPS

Abstracting FileMaker Pro Files with the Self Function

The purpose of the Self function may not be readily apparent at first glance. It's quite simple, but enormously powerful. Find out how to use it.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR TIPS

Concatenate FileMaker Pro Fields Conditionally without Logical Functions

Learn a cool technique for concatenating fields conditionally without the need for convoluted conditional statements.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR ANSWERS

Improve Your FileMaker Pro Skills

If you've been working with FileMaker Pro for many years, but don't feel like you've reached the expert level yet, these four suggestions will help you focus on how to improve your skills for the next level of technical prowess.

By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

SOLUTION DEVELOPMENT

Create a FileMaker Pro Help System

Help users by providing an intuitive and easy to maintain Help system in every database you build.

By Daniel Kaan, Data Organisation Pty Ltd principal

Subscribe to FileMaker Advisor Magazine

Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.

FileMaker.Advisor.com

Subscribe to Advisor Basics of FileMaker Pro

Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!

FileMaker.AdvisorBasics.com

Secrets Of The Top Experts -- Now!

See exactly how to do it, step-by-step, in Advisor Academy CDs created by the top experts. Click to see what you can learn right now.

AdvisorAcademy.com

Free E-Newsletters

Keep up! Hot News, How-To, Tips & Tricks, Expert Advice, and more. Click to request your's free.

AdvisorUpdate.info

Need Know-How Now?

What direction are you going with your business? Advisor Guides are packed with the answers you need to work smarter. Can you afford to fall behind?

AdvisorStore.com

Showcase Your Smarts

Submit your tips, techniques and advice and let Advisor promote your business and build your career. Show the world what you know!

AdvisorTips.com

ADVISORAMA
The murals in restaurants are on par with the food in museums.
-- Peter De Vries

Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
Portions copyright ©1983-2007 Advisor Media, Inc. All Rights Reserved.
Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, Inc. in the United States and/or other countries.
FileMaker is a trademark of FileMaker, Inc. Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
domino-144.advisor.com my.advisor.com 05/11/2008 04:38:44 PM