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.
You are not signed-in. If you are a subscriber to this publication, sign-in above to access locked articles. To subscribe or renew go to www.AdvisorStore.com.
Here's a formula that tests to see if a record belongs to the currently logged-on account, but also allows the full-access password to see all records.
Often, data you want to import into FileMaker Pro comes to you in a format that is not conducive to the proper design of a database. Here's a parsing technique to speed things up.
By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor
Complex hierarchies can be tricky. Here's how to treat top-level items, work with hierarchical found sets, let users expand and collapse records independently, and more.
You're using ESS to link a FileMaker Pro database to an external database, and you've changed some values. Some of these values sync and some don't. Here's the answer to this mystery.
By Chris Moyer, technical editor; and Bob Bowers, techncial editor
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.
Most users don't even know how to cancel a script, but many users know how to accidentally type the right keys at the wrong time. So find out how to protect your solutions with the Allow user Abort script step.
By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor
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.
Find out what to do if you want to normalize contact data, but you don't have complete contact information.
By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor
Effective deployment and administration of either version of FileMaker Server 9 requires you to open a number of TCP ports on the various machines that comprise the FileMaker Server 9 environment.
By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor
By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor
Often, data you want to import into FileMaker Pro comes to you in a format that is not conducive to the proper design of a database. Here's a parsing technique to speed things up.
By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor
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.
By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor
Be a better developer by learning how to implement preventative measures, focus on good communications skills, and hone your technical troubleshooting abilities.
In previous columns, I've discussed phone number formatting formulas from simple auto-enter formulas all the way up to custom recursive functions. In this tip, I want to talk about the relationship between auto-enter and validation.
By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor
Naming conventions are so important that FileMaker, Inc. commissioned a white paper from some of the top FileMaker developers in the world. Find out more.
By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor
Find out what to do if you want to print mailing labels for each contact in a customer record, but all the contacts are listed under one customer name.
By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor
It's simple to sort a portal by one of the fields from the table occurrence specified in the definition of the portal. But what if you want to sort by a field several relationships away? Learn how to do it.
By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor
Which approach is best for a solution: Table-to-table, distribution, separation, or session? Learn about each, and the pros and cons of these approaches.
By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor
One of the best ways to be an efficient developer is to master FileMaker Pro's keyboard shortcuts. If you make an effort to learn them, you'll accumulate some truly useful time savers. Here are some favorites.
By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor
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.
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
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.
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
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.
Get it all -- every current and past ADVISOR tech/business publication, now all-in-one subscription, with new articles and a huge reference library packed with expert advice, how-to and downloads. Subscribe now to get it all.
Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.
Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!
= free access
= subscriber-only
= not online (on CD or in print)
= has download
RSS Feed
RSS FEEDS
