- [Voiceover] The logical function group contains…some of the most powerful and interesting functions…available in FileMaker Pro, but unlike other categories…of functions where we've been reviewing,…that have several functions that often have very similar…syntax and behavior, the logical functions…are a collection of unique and sometimes complex…functions that really break up into two categories.…I'll show you examples of both.…The first of those categories within the logical functions…are used for performing conditional operations,…and really these might be the most valuable functions…in all of FileMaker.…Let's go into Manage, Database, so I can show you…what I'm talking about.…
Let's create a field called Commission,…because let's say what we're doing here,…is creating a field so that we can calculate…the salesperson commission.…So we're going to create that field as a calculation,…and let's say it's easy enough for us to say,…all right, the invoice subtotal times .05.…That doesn't take any functions or any knowledge…
Author
Cris Ippolite
Released
5/10/2016- Understanding the FileMaker Pro interface
- Creating new FileMaker apps from spreadsheets
- Building tables and relationships
- Defining primary and foreign keys
- Working with fields
- Creating, editing, and deleting records
- Importing and exporting data in a FileMaker Pro database
- Creating and formatting layouts
- Finding data and sorting data
- Printing from FileMaker
- Building reports
- Using calculations
- Scripting
- Triggering scripts
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome52s
-
-
1. Getting Started
-
What is a database?2m 44s
-
Tour essential preferences6m 11s
-
Explore the interface5m 40s
-
Tour the Launch Center4m 46s
-
-
2. FileMaker App Creation Essentials
-
3. Creating Tables
-
4. Creating Relationships
-
Understand key fields6m 25s
-
5. Working with Fields
-
Understand field types7m 47s
-
Define fields8m 1s
-
Add fields to layouts5m 15s
-
Use field auto-enter options10m 5s
-
6. Working with Container Fields
-
7. Working with Records
-
Create and duplicate records6m 21s
-
Edit and lock records4m 4s
-
-
8. Importing and Exporting
-
Import data6m 44s
-
Export data4m 50s
-
-
9. Creating Layouts
-
Introducing layouts5m 1s
-
Work with layout themes7m 48s
-
-
10. Working with Layouts
-
Understand layout parts7m 28s
-
Preview the Inspector3m 2s
-
11. Formatting Layout Objects
-
Apply themes to layouts2m 11s
-
Apply screen stencils6m 13s
-
Apply gradients2m 3s
-
Understand states7m 1s
-
Set field behaviors2m 3s
-
Use the tab control feature7m 26s
-
Set the tab order3m 29s
-
12. Finding Data
-
Establish search operators5m 19s
-
13. Sorting Data
-
Sort with single criteria5m 48s
-
Sort with related fields1m 52s
-
Sort with multiple criteria1m 43s
-
Sort using custom values2m 25s
-
-
14. Value Lists
-
15. Printing and Saving
-
Print merge letters3m 54s
-
Save as PDF or Excel4m 48s
-
16. Reports
-
Create subsummary reports8m 37s
-
Add charts to reports7m 37s
-
17. Calculation Essentials
-
Introducing calculations2m 58s
-
Use number functions7m 6s
-
Use date and time functions2m 43s
-
Use text functions9m 42s
-
Use get functions4m 41s
-
Use logic functions10m 35s
-
-
18. Script Essentials
-
Tour the Script workspace3m 29s
-
Create multiline scripts8m 7s
-
Use script parameters2m 46s
-
19. Script Triggers
-
Introducing script triggers2m 12s
-
Use object-based triggers10m 22s
-
Use layout-based triggers7m 25s
-
-
Conclusion
-
Goodbye35s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Use logic functions