Book description
You don’t need a technical background to build powerful databases with FileMaker Pro 13. This crystal-clear guide covers all new FileMaker Pro 13 features, such as its improved layout tools and enhanced mobile support. Whether you’re running a business, printing a catalog, or planning a wedding, you’ll learn how to customize your database to run on a PC, Mac, Web browser, or iOS device.
The important stuff you need to know:
- Get started. Tour FileMaker Pro’s features and create your first database in minutes.
- Access data anywhere. Use FileMaker Go on your iPad or iPhone—or share data on the Web.
- Dive into relational data. Solve problems quickly by connecting and combining data tables.
- Create professional documents. Publish reports, invoices, catalogs, and other documents with ease.
- Harness processing power. Use calculations and scripts to crunch numbers, search text, and automate tasks.
- Add visual power and clarity. Create colorful charts to illustrate and summarize your data.
- Share your database on a secure server. Add the high-level features of FileMaker Pro Advanced and FileMaker Pro Server.
Publisher resources
Table of contents
- FileMaker Pro 13: The Missing Manual
- The Missing Credits
- Introduction
-
1. Getting Started with FileMaker
- 1. Working with Your Database
-
2. Organizing and Editing Records
- Views
-
Advanced Find Techniques
- Multiple Requests
- Finding by Omitting
- Refining a Found Set with Omit Commands
- Constraining and Extending the Found Set
-
Refining Searches with Find Operators
- Match Whole Word (=), Match Phrase (“”), and Match Entire Field (= =)
- Find Duplicate Values (!)
- Less than (<), Less than or Equal (≤), Greater than (>), and Greater than or Equal (≥)
- Range (…)
- Today’s Date (//) and Invalid Date or Time (?)
- Any One Character (@) and Any One Digit (#)
- Zero or More Characters, A.K.A. “Wildcard” (*)
- Relaxed Search (~)
- Modify Last Find
- Using the Find Pop-Up Menu
- Editing What’s in Your Fields
- Changing Text Appearance
- Checking Spelling
- Preview Mode and Printing
-
2. Building Your First Database
- 3. Creating a Custom Database
- 4. Adding Power to Your Database
-
3. Thinking Like a Developer
- 5. Creating and Managing a Relational Database
- 6. Field Options
- 7. Layout Mechanics
- 8. Layout Design
-
9. Understanding Calculations
-
Understanding Calculations
- Creating a Calculation
- The Structure of a Calculation
- Using Fields in Calculations
- Using Constants in Calculations
- Using Operators in Calculations
-
Functions
- Text Functions
- Text Formatting Functions
- Number Functions
- Date Functions
- Time Functions
- Timestamp Functions
- Container Functions
- Aggregate Functions
- Summary Functions
- Repeating Functions
- Financial Functions
- Trigonometric Functions
- Logical Functions
- Get Functions
- Design Functions
- Mobile Functions
- Custom Functions
- External Functions
- Expressions
- Using a Related Field in a Calculation
- Understanding the Specify Calculation Dialog Box
- Auto-Enter Calculations
- Validate Data Entry with a Calculation
- Commenting in Calculations
-
Understanding Calculations
- 10. More Calculations and Data Types
- 11. Understanding Scripts
-
12. Exploring Script Steps
- Go to Layout
- Go to Object
- Scripting for Fields
- Working with Records
- Finding Records
- Sorting Records
- Working with Windows
- Working with Files
- Printing
- Other Script Steps
-
4. Becoming a Power Developer
- 13. Applying Developer Utilities
- 14. Advanced Relationship Techniques
- 15. Reporting and Analysis
- 16. Advanced Calculations
-
17. Advanced Scripting
- Commenting Scripts
- Importing Scripts
- Communicating with Database Users
- Creating Modular Scripts
- Script Parameters
- Script Variables
- Handling Errors
- Advanced Script Triggers
-
Putting a Complex Script Together
- Planning the Script
- Considering Exceptions
- Creating Subscripts
-
Finishing the Subscripts
- The Find Unbilled Activity Subscript
- Copying and Editing Existing Script Steps
- Adding a Script Parameter to a Perform Script Step
- Checking a Subscript’s Result
- Finishing the Create Invoice Record Subscript
- Finishing the Process Timeslips Subscript
- Creating a Looping Script
- The Process Expenses Subscript
- Testing Scripts
-
5. Security and Integration
- 18. Adding Security
- 19. Sharing Data Using FileMaker Server
- 20. Sharing Data with WebDirect and FileMaker Go
- 21. Sharing Data with Other Systems
-
6. Appendixes
- A. Getting Help
- B. File Conversion
- C. Using the Insert Commands with Container Fields
- D. FileMaker Error Codes
- Index
- About the Authors
- Copyright
Product information
- Title: FileMaker Pro 13: The Missing Manual
- Author(s):
- Release date: June 2014
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781491901854
You might also like
book
FileMaker Pro 9: The Missing Manual
FileMaker Pro 9: The Missing Manual is the clear, thorough and accessible guide to the latest …
book
FileMaker Pro 11: The Missing Manual
This hands-on, friendly guide shows you how to harness FileMaker's power to make your information work …
book
FileMaker Pro 14: The Missing Manual
You don’t need a technical background to build powerful databases with FileMaker Pro 14. This crystal-clear, …
book
Special Edition Using FileMaker 9
Special Edition Using FileMaker 9 The only FILEMAKER 9 book you need We crafted this book …