A FMT Preferred FileMaker Consultant - Developer
Log in
Hot & Trending on FMT

Perfecting FileMaker Pro Recursion & Virtualization Part 2

Perfecting FileMaker Pro Recursion & Virtualization Part 2 Perfecting FileMaker Pro Recursion & Virtualization Part 2

Perfecting FileMaker Pro Recursion & Virtualization Part 2 explores the use of recursion and virtualization (through global variables) in solving complex data interconnectivity challenges using FileMaker Pro 12 in a multi-user client-server environment. Using a specific case study of an Excelisys project/client in the medical manufacturing industry, Andy discusses and demonstrate the dramatic performance benefits that can be gained with the techniques involved.

Have you ever had a FileMaker Pro project where each task depended on other tasks to be completed before it could start? How would you keep track of the projected completion date of the project as various tasks were completed or delayed? What if the project involved hundreds of tasks and tens of thousands of dependencies?

In my previous post, I introduced the challenge: Updating hundreds or thousands of tasks interconnected with tens of thousands of connections. We also took a look at a couple possible solutions, but determined that they were unworkable. In this second installment, we look at an alternate recursive approach and why it is superior to the one we discussed last time. Let’s take a look at this other possibility shall we…

FileMaker Pro Recursion

Sample of free PDF download

Please visit the Excelisys Tips-n-Tricks section of the website to download the article in its entirety as a PDF.

Andy Persons is a Lead Senior FileMaker Pro Developer with Excelisys:  Andy has been an industry leading FileMaker Pro developer creating FileMaker Pro solutions for over 17 years. In addition to being one of the lead developers of three top-rated and most-downloaded FileMaker Pro solutions of all-time; the FileMaker Business Tracker and the Excelisys eX-BizTracker & eX-BizTracker Pro jump-start solutions, he has shared his incredible and advanced talents by authoring numerous Tips-n-Tricks files and white papers, including Hierarchical Portals, Recursive Calcs, Audit Logs and Drag-and-Drop using http://www.filemaker.com/products/filemaker-pro/" href="http://www.filemaker.com/products/filemaker-pro/">FileMaker Pro.

*This article is provided for free and as-is, use and play at your own risk – but have fun! Excelisys does not not provide free support or assistance with any of the above. If you would like help or assistance, please consider retaining Excelisys’ FileMaker Pro consulting services.


We’ve assembled a team of brilliant developers creative problem solvers and consummate professionals, workhorses and web wizards, who work tirelessly to provide you with the best custom solutions to your data management needs. If you’re looking for spineless, Fritos-munching, Mountain-Dew-drinking, living-in-mommy’s-basement, tunnel-visioned order-takers, you won’t find them at Excelisys. We only hire the best.

And you should too.

Our team brings more than 200 years of combined experience in custom database development and management to bear on your solutions. In developer years, just like in dog years, that’s closer to 1,400 years. And 1,400 years ago the Byzantine Empire still existed. Think about it.

We’ve worked with everyone under the sun-from Adobe, the Ayn Rand Foundation, Chevron and Cisco Systems to the University of Chicago, Yoga Journal and Zenith Travel-and they all love us. We know you’re probably thinking, “Those are all huge companies with truckloads of money.” Don’t worry about that; from our perspective, no job is too small! In fact, size really doesn’t matter to us. And unlike most people who say it, we really mean it. Just ask Ted Cheeseman, CEO of Cheeseman’s Ecology Safaris, or Neil King, President of King Shots, Inc., or Todd Golebiewski, Manager of River View Campground & Canoe Livery. You can even call them. Just check our references section and you’ll find their numbers there.

We’ve received the most feedback and some of the highest scores on FindFileMakerDevelopers.com, the data management world’s Service Magic-esque client feedback interface. See what our clients are saying: http://filemakertoday.com/filemaker-integration/item/excelisys?category_id=20.

Call us geeks, but we love solving database management problems. Seriously. And our love for what we do shows in the solutions we provide to our clients. And our solutions make our clients love us back. In fact, we have a 95 percent client retention rate. They just keep coming back for more.

Website: www.excelisys.com