This is the eBook version of the printed book. This Short Cut presents a sampling of custom functions that we’ve found useful, or that serve as good examples of functions in our day-to-day practice. The functions are broken into groups according to their purpose, much as FileMaker’s calculation functions are. Please note that these functions are meant as examples—although the examples were not tested exhaustively, nor is this collection meant to be comprehensive. We hope you’ll find some of them helpful directly, or that reading and analyzing others might provide a springboard for your own ideas. Table of Contents Number Calculations Date Calculations Text and Data Conversions Email Tools List Handlers Developer Tools System Constants Toolkit for Complex Data Structures Data API Within FileMaker Data Tree Using XML as a Data Structure Path-Based Selections The Functions

FileMaker 8 Functions and Scripts Desk Reference is the only book on the market expressly focused on describing each calculation formula and how and when to use each one. With this book's real-world, concrete examples of how to use each function, you will go far beyond FileMaker 8's help system. Just as a dictionary helps supplement one's memory, this book is an invaluable companion to users working to develop solutions to their every day software problems.

If you're looking for the inside scoop on the latest version of FileMaker, you've come to the right place. Authors Scott Love and Steve Lane are FileMaker experts who were involved in the development of FileMaker 8, and they bring that knowledge to you in Special Edition Using FileMaker 8. Frequent tips, case studies, and thorough examples show you how to avoid mistakes and save time in developing databases with FileMaker 8. This is the comprehensive reference that every database developer needs on their shelf.

Maybe you know FileMaker, and you have used it for years, but need a quick reference, immediately accessible while not interrupting your work on screen. This is the only book on the market expressly focused on describing each calculation formula and how and when to use each! Filled with real-world, concrete examples, this book is an invaluable companion to readers working to develop solutions to their every day software problems. Contains hundreds of calculation functions, script steps, and operations that will appeal to every FileMaker user, new and old.

Used by millions worldwide, FileMaker Pro is an award-winning database program for managing people, projects, images, assets, and other information. It's easy to use and totally customizable--so long as you know what you're doing. But FileMaker Pro doesn't come with a printed manual, so FileMaker Pro: The Missing Manual is the authoritative, jargon-free book that should have been in the box. FileMaker Pro: The Missing Manual approaches FileMaker the way FileMaker approaches you: it's user-friendly and seemingly straightforward enough, but it offers plenty of substance worthy of deeper exploration. Packed with practical information as well as countless expert tips and invaluable guidance, it's an in-depth guide to designing and building useful databases with the powerful and pliable FileMaker Pro. Covering FileMaker for both Windows and Macintosh, FileMaker Pro: The Missing Manual is ideal for small business users, home users, school teachers, developers--anyone who wants to organize information efficiently and effectively. Whether you want to run a business, publish a shopping cart on the Web, plan a wedding, manage a student information system at your school, or program databases for clients, this book delivers. Author Geoff Coffey has many years of experience using FileMaker Pro (he was, in fact, an early beta tester for the product). Author Susan Prosser is a FileMaker Certified Developer who trains other developers. Together, Coffey and Prosser show you how to: Get FileMaker up and running quickly and smoothly Import and organize information with ease Design relational databases that are simple to use, yet powerful Take advantage of FileMaker Pro calculation capabilities Automate processes with scripting Customize FileMaker Pro to your needs and preferences Share information with other people (coworkers, clients, and customers) and other programs Understand and select the best security options What could easily come across as dry and intimidating--things like relational theory, calculations, and scripting--are presented in a way that is interesting and intuitive to mainstream users. In no time, you'll be working more productively and efficiently using FileMaker Pro.

FileMaker Pro 8.5 Bible provides step-by-step procedures for using virtually all FileMaker Pro features and performing all tasks. This best-selling volume has been updated to reflect Version 8.5, the latest version of FileMaker Pro workgroup database. Applicable to both the Mac and Windows versions of FileMaker Pro, this Bible shows readers how to create and work with databases and includes detailed ScriptMaker (scripting) explanations for automating FileMaker. Other topics covered include calculations and computations; data exchange; creating and using templates; linking databases; using FileMaker in workgroups; Web publishing; plug-ins; and advanced database connectivity.