Creating scripts in FileMaker is an essential part of developing a FileMaker database that's…going to be easy for your users to work with. And making scripts as intelligent as possible…will take much of the guesswork out of using your database. A great way to add intelligence…to your script is by adding conditions to the scripts. If you recall in the calculations…chapter, we discussed a group of functions called logical functions. These allow you…to perform a test or ask a question and then provide multiple results depending on whether…or not the test provided true answer or a false. You can do the same thing in a script…using a set of script steps that are based on the same if principle. They'll allow you…to ask a question during your script and then perform different actions based on whether…or not the condition was met or whether it was false. Let's take a look at a set of scripts…under our Manage scripts, and we see we've got this Print Welcome Letter. Let's duplicate…this--I am going to hit Duplicate button right there, and we are going to create a new one,…
Author
Released
5/29/2012- Comparing flat vs. relational databases
- Creating databases from templates
- Determining what tables you need
- Understanding relationship types
- Defining key fields and creating relationships between tables
- Creating fields
- Using new FileMaker 12 container fields
- Creating, duplicating, editing, and deleting records
- Importing and exporting data
- Managing layouts and layout objects
- Applying new FileMaker 12 themes to layouts
- Finding records and working with found sets
- Building reports and charts
- Authoring calculations
- Creating and triggering scripts
- Working with relationships in scripts, calculations, and charts
Skill Level Beginner
Duration
Views
Related Courses
-
Advanced FileMaker Pro 12
with Cris Ippolite7h 33m Advanced -
Learning FileMaker Go
with Cris Ippolite1h 15m Intermediate
-
Introduction
-
Welcome1m
-
Using the exercise files1m 7s
-
-
1. Getting Started
-
What is a database?2m 49s
-
Exploring the interface8m 10s
-
-
2. Database Creation Essentials
-
Adding tables by importing3m 10s
-
3. Creating Tables
-
4. Creating Relationships
-
Understanding key fields4m 19s
-
5. Working with Fields
-
Defining fields7m 22s
-
6. Working with Container Fields
-
7. Working with Records
-
8. Importing and Exporting
-
Importing data9m 8s
-
Exporting data5m 10s
-
-
9. Creating Layouts
-
Introducing layouts4m 51s
-
-
10. Working with Layouts
-
Understanding layout parts6m 31s
-
Previewing the new Inspector1m 22s
-
11. Formatting Layout Objects
-
Applying Screen Stencils4m 3s
-
Applying gradients2m 25s
-
Understanding object states2m 18s
-
Setting field behaviors3m 58s
-
Using the Tab Control feature11m 17s
-
Setting the tab order5m 1s
-
12. Finding Data
-
Saving find requests5m 55s
-
13. Sorting Data
-
Sorting with one criterion4m 40s
-
Sorting with related fields2m 23s
-
Sorting using buttons4m 31s
-
-
14. Value Lists
-
Introducing control styles5m 40s
-
-
15. Printing and Saving
-
Printing merge letters5m 20s
-
16. Reports
-
Adding charts to reports10m 23s
-
17. Calculation Essentials
-
Introducing calculations2m 46s
-
Using number functions10m 29s
-
Using text functions12m 35s
-
Using get functions5m 26s
-
Using logic functions11m 39s
-
-
18. Script Essentials
-
Creating multi-line scripts8m 39s
-
Using the New Window script step10m 58s
-
Using script parameters4m 28s
-
19. Script Triggers
-
Using object-based triggers10m 49s
-
Using layout-based triggers6m 40s
-
20. Using Relationships
-
Using related fields6m 32s
-
-
Conclusion
-
Goodbye1m 16s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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: Understanding the If script step