Skip to Main Content
FileMaker Pro 14: The Missing Manual
book

FileMaker Pro 14: The Missing Manual

by Stuart Gripman, Susan Prosser
May 2015
Beginner to intermediate content levelBeginner to intermediate
970 pages
32h 12m
English
O'Reilly Media, Inc.
Content preview from FileMaker Pro 14: The Missing Manual

Chapter 12. Understanding Scripts

When you created the Lease Agreement database in Chapter 4 and Chapter 5, you wrote a script to sort records viewed in a list (Writing a Basic Script). That script didn’t do anything you couldn’t have done manually. But since it remembers a sorting setup, the script runs faster and more accurately than with manual commands. To make it even more convenient, you attached the script to a button that your users could click to sort data without the need to understand how to set up a Sort window. For even more automation, you gave the list layout a script trigger that ran the Sort script every time that layout is viewed. It’s almost like your database knows what your users need before they do.

That basic script introduced you to many of the advantages of scripting. Here are the main reasons to add scripts to your database:

  • Efficiency. For just about any process, a script can run faster than you (or your users) can issue the same commands.

  • Accuracy. Once you set it up, a script won’t leave out a step or perform a series of steps out of order.

  • Convenience. You don’t have to remember how to do a process that you don’t perform often.

  • Automation. With script triggers, processes can run without you explicitly running the script. In many cases, users won’t even know a script is running. They’ll just see the results.

  • Complex processing. Some processes just aren’t possible (or maybe they’re not feasible) without a script handling the grunt work.

Most scripts you’ll write ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

FileMaker Pro 11: The Missing Manual

FileMaker Pro 11: The Missing Manual

Stuart Gripman, Susan Prosser
FileMaker Pro 12: The Missing Manual

FileMaker Pro 12: The Missing Manual

Susan Prosser, Stuart Gripman
FileMaker Pro 10: The Missing Manual

FileMaker Pro 10: The Missing Manual

Susan Prosser, Geoff Coffey
FileMaker Pro 9: The Missing Manual

FileMaker Pro 9: The Missing Manual

Geoff Coffey, Susan Prosser

Publisher Resources

ISBN: 9781491917473Supplemental ContentErrata Page